FAQ Error

[Steve Machol]

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.

[Jason2]

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 Jason

[Steve Machol]

You do that in the 'Export' tab in phpMyAdmin. I do not have more specific instructions for this.

[Jason2]

I asked my host if they could do this for me, and they`ve just asked me this;

Does vbulletin use imagemagick?

Please advise.

Regards Jason

[Steve Machol]

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 Settings

[Jason2]

They said you might want take a look at this to see if any of this is casing the issue;

http://www.techsupportteam.org/phpinfo.php

I`m going try and copy and paste the test boards FAQ table and see if that fixes it.

Regards Jason

[Jason2]

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;

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

Regards Jason

[Steve Machol]

As per post #16 you have to drop that table first.

[Jason2]

. 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 did drop the table and pasted the .sql file and got the above error.

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 Jason

[Steve Machol]

You cannot get this if that table doesn't exist:

MySQL said:
#1050 - Table 'faq' already exists

[Jason2]

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;

 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

The table is just called 'FAQ' and is at the top, do I have to name it 'vbulletin FAQ' as that is what it had before, if so how do I do that?

Regards Jason

[Steve Machol]

MySQL Error : Table 'theco55_vbulletin.vbulletinfaq' doesn't exist

That pretty much means what it says too.

[Jason2]

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 Jason

[Steve Machol]

Whatever table you are trying to replace, you need to drop first, then make sure your sql used the correct table name.

[Jason2]

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 Jason