Make a backup of that faq table with phpMyAdmin, then paste the text of that backup into the SQL box for the db missing the faq records. You will need to drop that faq table first then change the text of that backup to use the same table name.
FAQ Error
Collapse
X
-
Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
-
Have you got some kinda guide as I`m still all new to this? How would I make a backup of that single table? And for pasting the.sql, do I go to the database missing the FAQ records, click structure on FAQ, and then paste the .sql into that box? I see the word drop, so I just press that then paste the text?
Regards JasonComment
-
You do that in the 'Export' tab in phpMyAdmin. I do not have more specific instructions for this.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
That has nothing to do with this situation, but yes vB can take advantage of ImageMagick. You can do that here:
Admin CP -> vBulletin Options -> Image SettingsSteve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
They said you might want take a look at this to see if any of this is casing the issue;
I`m going try and copy and paste the test boards FAQ table and see if that fixes it.
Regards JasonComment
-
Ok, I`ve got .sql file from the test boards database for the FAQ. I dropped the table and then pasted the .sql file into the box and clicked ok, then it said; " #1050 - Table 'faq' already exists"
I don`t know if I`m doing it in the wrong place... could you say where I go to paste it in
EDIT: I click the SQL tab at the top of the phpMYADMIn and then paste the code in, but I changed the code that says database name to the database I`m importing it too, press go and then get the following error;
Code:SQL query: -- -- Database: `theco55_vbulletin` -- -- -------------------------------------------------------- -- -- Table structure for table `faq` -- CREATE TABLE `faq` ( `faqname` varchar( 250 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '', `faqparent` varchar( 50 ) NOT NULL default '', `displayorder` smallint( 5 ) unsigned NOT NULL default '0', `volatile` smallint( 5 ) unsigned NOT NULL default '0', `product` varchar( 25 ) NOT NULL default '', PRIMARY KEY ( `faqname` ) , KEY `faqparent` ( `faqparent` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1; MySQL said: [URL="http://dev.mysql.com/doc/mysql/en/error-messages-server.html"][/URL] #1050 - Table 'faq' already exists
I looked on the MYSQL and this is the description that matches the error number -- Error: 1050 SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR)
Message: Table '%s' already exists
Last edited by Jason2; Mon 7 Jan '08, 12:44pm.Comment
- Error: 1050 SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR)
-
As per post #16 you have to drop that table first.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
. I dropped the table and then pasted the .sql file into the box and clicked ok, then it said; " #1050 - Table 'faq' already exists"
I don`t have a .faq table in my database now for my live forums.
Or do you mean drop the test boards database faq table?
Regards JasonComment
-
You cannot get this if that table doesn't exist:
MySQL said:
#1050 - Table 'faq' already existsSteve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
I did that and I`ve got the table FAQ showing at the top of the database for my live forum.
It seems as though there all there, but when I click FAQ I get database error;
Code:Invalid SQL: SELECT faqname, faqparent, displayorder FROM vbulletinfaq AS faq WHERE 1=1; MySQL Error : Table 'theco55_vbulletin.vbulletinfaq' doesn't exist Error Number : 1146 Date : Monday, January 7th 2008 @ 02:09:18 PM Script : [URL]http://techsupportteam.org/forum/faq.php[/URL] Referrer : [URL]http://techsupportteam.org/forum/index.php[/URL] IP Address : 82.16.245.186 Username : Jason Classname : vb_database MySQL Version : 5.0.27-standard
Regards JasonComment
-
MySQL Error : Table 'theco55_vbulletin.vbulletinfaq' doesn't exist
That pretty much means what it says too.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Yes, that`s because the table is at the top and just says the name 'faq'. Where as before is was 'vbulletinfaq' so I`m wondering if I`ve got rename it, but how do you rename a table?
Is I browse the 'faq' table It says a total of 30 rows, and I can see the faq like "Why register" ect..
I can take a screenshot if needed.
Regards JasonComment
-
Whatever table you are trying to replace, you need to drop first, then make sure your sql used the correct table name.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Here`s a screenshot;
I`ve circled where the faq table is and if you see to the right, all the FAQ are there. Now I need to rename faq to; 'vbulletinfaq' as that is what it was before.
So you run some kinda query like this?
rename table phpbb_tablename to phpbbrc1_tablename;
Regards JasonComment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment