Recent Topics

1 Jul 08, 2007 08:01    

My b2evolution Version: Not Entered

I am moving my blog to a new host and decided to upgrade b2evolution as well.
- I have successfully done a new install of 1.10.2 and modified the _main.php to have all needed elements.
- I have moved all images from old site to new (inside Media folder)
- Receive error when attempting to import database. From current host it looks like I am only able to export the MySQL DB through a backup wizard that provides a .gz file. File size is 860 KB. When I attempt to import existing DB into new one I receive this error message:

-------------------------------------------------
SQL query:
CREATE TABLE `evo_antispam` (
`aspm_ID` bigint( 11 ) NOT NULL AUTO_INCREMENT ,
`aspm_string` varchar( 80 ) NOT NULL default '',
`aspm_source` enum( 'local', 'reported', 'central' ) NOT NULL default 'reported',
PRIMARY KEY ( `aspm_ID` ) ,
UNIQUE KEY `aspm_string` ( `aspm_string` )
) ENGINE = MYISAM AUTO_INCREMENT =19 DEFAULT CHARSET = latin1
MySQL said:
#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 CHARSET=latin1' at line 7
------------------------------------------------

Any advice on how to resolve would be fantastic!

- Troy @ TLC Creative

2 Jul 12, 2007 03:51

Try unzipping the file (tar gz; use google) and see if it comes up with a sql file in plain ascii (readable). Import thisnew file.

If this doesn't work check if the CHARSET is set correctly (is the source in Latin-1, is the target database set in latin-1 or UTF-8)

Good luck


Form is loading...