Email Marketing Software for your Mailing Lists - Re:SQL error #1064 when importing `jos_acajoom_lists`

Fritz
User

Fresh Boarder

Posts: 2

Karma: 0

SOLVED - SQL error #1064 when importing `jos_acajoom_lists` - 2008/07/18 16:24 My website is running on MySQL 4.0.15 and is doing well.

When I export my Joomla site and import it into MySQL 5.0.33 I get the following error:

#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 '0'',
`sendername` varchar(64) NOT NULL default '''',
`senderemail` varchar(6' at line 5

The image below shows the upper part of the table that is being processed:

Does anybody know what is going on? Any help is greatly appreciated.

Thanks

Fritz

Post edited by: Fritz, at: 2008/07/18 16:28

Post edited by: kornikopic, at: 2008/07/21 22:54

| | To post on the forum you need to sign in.

Fritz
User

Fresh Boarder

Posts: 2

Karma: 0

Re:SQL error #1064 when importing `jos_acajoom_lists` - 2008/07/19 19:21 Dear all,

the table was apparently messed up because of an uninstall that failed (I uninstalled PerForms which went wrong).

So the issue has nothing to do with Acajoom. A backup solved the problem.

Best regards,

Fritz

| | To post on the forum you need to sign in.