On these pages are my WordPress plugins, the odd article and my Support Forum.

For my random rantings on everything else please visit my blog at Yellow Swordfish

WP Plugins


Articles

If you find any of my plugins useful, please comsider a donation towards my running costs.

Thank you

Current User: Guest
Please consider registering

 
Search Forums:


 




Problem with wordpress database restoring.

UserPost

12:02 pm
25 Jun 2008


RecNes

Member

posts 33

 
1

Yesterday, to upgrade my blog to Wordpress 2.5.1, backed up my database and try to upgrade my old wordpress. After the upgrade  I get login error from WordPress. I try some ways to correct that problem, but I get different one each correction attempt. Then I decide to restore my backup and return to the old version WordPress.

I logged in to phpMyadmin and start to import old database. a few secons later I get the eroor message below:

[code]Error

SQL query : 

INSERT INTO `wp_sfposts` 
VALUES ( 22, 'selamlar… bu simple forumun Türkçe po dosyası lağzım.. Hiçbir yerde bulamadım.. Bazı yerlerin çevirisini beğenmedim..Elinizde mevcut mu acaba?\r\n', '2007-10-30 09:34:51', 12, , 6, 'engin', 'engin1984@gmail.com', 0, 0 ) ;

MySQL output :  
#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 ' 6, 'engin', 'engin1984@gmail.com', 0, 0)' at line 1
[/code]

I tried to remove that line from SQL file and re-restore the file but I get same error for next SQL query from next line.

I tried to restore my blog to my computer but get same things too.

Now my blog is disabled, and I don't know to what to do. Does anyone have an idea?

MySQL ver. 4.1.x (@ server)
MySQL ver. 5.0.x (@ local)
Simple:Press Forum ver.3.1.1 (Build 336)

2:40 am
26 Jun 2008


Yellow Swordfish

Admin

Peterborough, England

posts 4639

 
2

The problem here is that you are talking about a backup database. The piece of data it is falling over on is the user id (and that specific post was posted by a guest so it should be null.

The real question is why did the database backup not construct the correct query?

The only way I can think of is to go through the database backup line by line (for sfposts) and if there is no user id insert the word NULL in its place.



Reply to Topic: Problem with wordpress database restoring.

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 9 + 9        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

Zuke

17 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 15

Topics: 1779

Posts: 11998

Members:

There are 820 members

There are 750 guests


Yellow Swordfish has made 4639 posts

Top Posters:

Mr Papa - 1256

-Radio- - 481

ovizii - 93

jfv - 80

angelic007 - 66

Administrator: Yellow Swordfish | Moderators: Yellow Swordfish, Mr Papa, -Radio-


© Simple:Press Forum - Version 3.1.4 (Build 357)