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

Support Forum : Problem with wordpress database restoring.

In preparation for the release of Simple:Press Version 4.0, the Support Forum has moved to a new site dedicated to the plugin. This will also be the future home for Simple:Press Forum.


Version 3.1.4 will still be available for download here in the short term.


For the support forum - and to visit our new site and to get details of version 4.0, click on the logo to take you to simplepressforum.com

This forum is currently locked - access is read only
Current User: Guest
Please consider registering

 
Search Forums:


 




Home Forums Simple:Press Forum Version 3.0 to 3.1.4 Problem with wordpress database restoring.

Problem with wordpress database restoring.
Page: 1
UserPost

12:02 pm
25 Jun 2008


RecNes

Member

posts 44
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 5252
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.
Page: 1


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: 8 + 4        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

8 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 16

Topics: 2068

Posts: 14091

Members:

There are 1003 members

There are 837 guests


Yellow Swordfish has made 5252 posts

Top Posters:

Mr Papa - 1602

-Radio- - 558

ovizii - 114

jfv - 82

angelic007 - 72

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


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