DB - Backup and restore problem

General discussions Forum for everything that does not fit elswhere in the phpbb SEO forums.

Moderator: Moderators

DB - Backup and restore problem

Postby GeckoDoIt » Tue Jul 17, 2012 2:07 am

Hi,

I have your SEO mod installed and it works great. However, I have a problem restoring the db! (intend to run locally)

I get DB Syntax Error in Table phpbb_3posts and field post_username for everytime I am trying to import the db, however, at different rows (or posts if it clarifyes things). See below. The live db also have no values in those fields. The live site works without any problem.

ps. I must admit I have made upgrades directly from phpbb3 website, which might not have been the best idea.

Would re-installing your tool make any difference?

I hope someone can help me with this problem, or lead me in the right direction.

My board is located at http://www.thailandsforum.se/forum/

Error in Query:
INSERT INTO `phpbb_3posts` (`post_id`,`topic_id`,`forum_id`,`poster_id`,`icon_id`,`poster_ip`,`post_time`,`post_approved`,`post_reported`,`enable_bbcode`,`enable_smilies`,`enable_magic_url`,`enable_sig`,`post_username`,`post_subject`,`post_text`,`post_checksum`,`post_attachment`,`bbcode_bitfield`,`bbcode_uid`,`post_postcount`,`post_edit_time`,`post_edit_reason`,`post_edit_user`,`post_edit_count`,`post_edit_locked`) VALUES ('69580','9166','53','1239','0','78.69.33.172','1230442260','1','0','1','1','1','1','','Re: Jupaporn - The story','Tack Leo, jag hoppas att du hade en underbar Jul...\n\nSen
Generated by SRT Generator

+I am using phpmyadmin and MySql 5.0.51a both locally and with my host. The host is experianced with phpbb and a part of the swedish phpbb community. I pressume his server is ok.
+I have used MySql dumper as my DB is 27 MB. I have also tried without.
+I have downloaded several copys of the db.
+I have downloaded from another computer but same error
+Anyone who have an idea about what is going wrong and how to fix it?
+The community was created 2007 and started on PHPbb2

ps. as far as I know my board is working without any problem but I still have this field issue
GeckoDoIt
 
Posts: 3
Joined: Tue Jul 03, 2012 11:09 am

Advertisement

Return to General Discussions

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 2 guests