Phpbb last resort

atomicant_2005 · #1 Mar 8th, 2006, 18:43

ok, basically i have had this problem for 2 weeks now, i changed web host, installed a new forum onto the new server, and tried to upload a backup. but it was too large after alot off reasearch and questions realised i had to break them up and use phpmyadmin, SO i have installed the broken up files via phpmyadmin, my 9mb file was broken up into 9 chunks, BUT when i imported it 2 of the 9 came up with the following errors:

Quote:

Quote:
SQL query:
INSERT INTO phpbb_search_wordlist( word_text, word_id, word_common )
VALUES (
'scared', '3470', '0'
);

MySQL said:
#1062 - Duplicate entry 'scared' for key 1
SQL query:
SELECT *
FROM
WHERE CONCAT_WS( "-", word_text, word_id, word_common ) = "scared"
ORDER BY word_text, word_id, word_common
MySQL said:
#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 'WHERE CONCAT_WS( "-", word_text, word_id, word_common )

and

Quote:

Quote:
SQL query:
CREATE TABLE phpbb_themes_name(
themes_id smallint( 5 ) unsigned NOT NULL ,
tr_color1_name char( 50 ) ,
tr_color2_name char( 50 ) ,
tr_color3_name char( 50 ) ,
tr_class1_name char( 50 ) ,
tr_class2_name char( 50 ) ,
tr_class3_name char( 50 ) ,
th_color1_name char( 50 ) ,
th_color2_name char( 50 ) ,
th_color3_name char( 50 ) ,
th_class1_name char( 50 ) ,
th_class2_name char( 50 ) ,
th_class3_name char( 50 ) ,
td_color1_name char( 50 ) ,
td_color2_name char( 50 ) ,
td_color3_name char( 50 ) ,
td_class1_name char( 50 ) ,
td_class2_name char( 50 ) ,
td_class3_name char( 50 ) ,
fontface1_name char( 50 ) ,
fontface2_name char( 50 ) ,
fontface3_name char( 50 ) ,
fontsize1_name char( 50 ) ,
fontsize2_name char( 50 ) ,
fontsize3_name char( 50 ) ,
fontcolor1_name char( 50 ) ,
fontcolor2_name char( 50 ) ,
fontcolor3_name char( 50 ) ,
span_class1_name char( 50 ) ,
span_class2_name char( 50 ) ,
span_class3_name char( 50 ) ,
fontcolor5_name char( 50 ) DEFAULT 'Administrators'color ', fontcolor6_name char(50) DEFAULT 'Moderators ' color',
PRIMARY KEY ( themes_id )
);

MySQL said:
#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 'color',
fontcolor6_name char(50) DEFAULT 'Moderators' color',

i don't have a clue what to do. speak in noob language please

sypher · #2 Mar 9th, 2006, 00:39

Basically you have messed it up for yourself

I would wipe it all of if i was you and start again.

Copy the database from the old host and upload to the new one (phpmyadmin has a db standard limit of 51mb)
Upload all the pages via ftp and set all the permissions. Also check config files to see if they need to be directed to the new domain.

and done

atomicant_2005 · #3 Mar 9th, 2006, 15:05

the domain is the same, do u mean copy the entire database rather than a back up and simply upload it via ftp.

what do u mean by changing the permissions do u mean the read write execute thing?

sypher · #4 Mar 9th, 2006, 17:09

You need to download the database go into phpmyadmin and upload it there. (Using the same database name, and username, password.

Yes read write execute permissions.

atomicant_2005 · #5 Mar 9th, 2006, 17:21

how do u upload a 9mb database?what permission should i set it to?

also which database name should i use or doesn't it matter unless there the same?

atomicant_2005 · #6 Mar 9th, 2006, 18:18

i think i've done what u said but now it says:

Quote:

phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'erikablack1.phpbb_config' doesn't exist

SELECT * FROM phpbb_config

Line : 166
File : e:\domains\e\erikablack.co.uk\user\htdocs\forum\co mmon.php

sypher · #7 Mar 9th, 2006, 20:59

You mustnt be uploading all the db info as its saying that the table doesnt exist.

Check wether is does in ur phpmyadmin.

atomicant_2005 · #8 Mar 10th, 2006, 10:31

i've decided to result to using bigdump again. but came to a problem strait away.

Quote:

Processing file: phpbb_db_backup[2].sql
Starting at the line: 3001
Error at the line 3001: b_posts` VALUES (2740, 326, 1, 108, 1118098661, '50040340', '', 1, 1, 1, 1, NULL, 0);
Query: b_posts` VALUES (2740, 326, 1, 108, 1118098661, '50040340', '', 1, 1, 1, 1, NULL, 0);
MySQL: 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 'b_posts` VALUES (2740, 326, 1, 108, 1118098661, '50040340', '',
Stopped on error

are these problems solveable?

sypher · #9 Mar 10th, 2006, 16:09

Not if theres an error with the db info.

You may have to start again.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
phpBB	alexgeek	Website Planning	34	Oct 2nd, 2007 23:30
forum phpbb	MetallicWarfare	Webforumz Cafe	13	Aug 15th, 2007 15:52
Help with Phpbb forum	Ofear	Scripts and Online Services	8	Jul 24th, 2007 13:00
Free PHPBB?	collinsc	PHP Forum	13	Mar 12th, 2007 18:01
phpbb Forums mod	saltedm8	PHP Forum	10	May 9th, 2006 22:27

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
Phpbb last resort