Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › Restore PS2 DB Import error

Restore PS2 DB Import error

Thread began 4/30/2010 3:49 pm by msjj000 | Last modified 5/03/2010 7:18 am by Jason Byrnes | 1094 views | 2 replies |

4/30/2010 3:49 pm | #1 msjj000Beta Tester

Restore PS2 DB Import error

Hi WA,

I have had to move my live store and I have made backups of the database as I normally would. When I restore I get the following error and only half the products are loaded and the user table isn't loaded at all. The other tables appear to load ok. I can restore an earlier backup unfortunately its a month old and missing rescent sales, user data etc.

I'm running MySQL v5.x. It is PS2 with PowerCMS tables.

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 '&phpMyAdmin=e29fdd1e0a5d3b84d3d60095a7e6f9b9 '<p><span style="font-size: 12pt; f' at line 4

Can you point me in th eright direction please?

Thanks, Mark.

4/30/2010 4:02 pm | #2 msjj000Beta Tester

I grabbed the older database and extracted the products table and then imported it. The same error occured. Hope this helps pinpoint the problem although it doesn't get me live again.

5/03/2010 7:18 am | #3 Jason ByrnesWebAssist

somewhere in your restore script is the following value:
'&phpMyAdmin=e29fdd1e0a5d3b84d3d60095a7e6f9b9 '<p><span style="font-size: 12pt; f'

that is causing the error.

look for that value in the restore script.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.