Hi all,
I'm moving the firefox forums (
www.firefox.dajoob.com ) to my server (
http://firefox.coolestech.com ), but I'm getting SQL syntax errors, because dajoob uses SQL 5.1.6, and I use 4.0.27 . Does anyone know how to convert the database, so it can be used?
Thanks.
Oh bother, Protoman, you said on MSN that you didn't have time. oh well, here is the error:
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.8.0.3
--
http://www.phpmyadmin.net
--
-- Host: dajoob.com
-- Generation Time: Jul 08, 2006 at 12:01 PM
-- Server version: 5.1.6
-- PHP Version: 5.1.2
--
-- Database:
mybb
--
CREATE DATABASE
mybb DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line
Remove this DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci.
Should fix your problem. Happened to me before, I removed that and it fixed my problem.
You should probably search through the file for similar phrases, as they're probably appended to each table structure query as well.
Yeah it will be on any CREATE query.
So tables, the database, etc.
OK, but could someone please edit the file for me? I"m no good at SQL.
MSN:
[email protected]
Just remove that part of the line anywhere you see it.
Nevermind, DrPoodle did it for me.
