Bad SubDomain SQL query.

[Albal]

I am receiving the 'Bad Subdomain SQL query' error on my site. My site hasn't been moved from another host/server.

 

I have followed the instructions on the bug reports and ran the following:

 

INSERT INTO `ps_subdomain`( `id_subdomain`, `name` )
VALUES (
'1', 'www'
)

 

 

But upon running that I receive this error:

#1033 - Incorrect information in file: './dbname_ps/ps_subdomain.frm'

 

 

The ps_subdomain.frm table contains the following:

 

 

SELECT * 
FROM  `ps_subdomain` 
LIMIT 0 , 30

 

I have tried searching for this issue but haven't found anything.

 

Does anyone know how to fix this? Any help is much appreciated.

[phrasespot]

What is the PS version? First check the table:

 

CHECK TABLE ps_subdomain FAST QUICK;

 

What is the message you get?

 

Then get everthing from the table and paste here if the previous does not indicate an error.

 

SELECT * FROM ps_subdomain

[ssekazinga]

Hi Albal,

Go into settings life in config floder and comment out the Cookie lines.

 

//define('_COOKIE_KEY_', 'mRIubjsMH0qkCoxc1');
//define('_COOKIE_IV_', 'hhkYE6');

 

Its want i did and it cleared.

 

Good luck

[jpryce]

My database prefix is ps2_ so obviously when it's looking for ps_subdomain it ain't finding anything. my settings.inc file is fine so any ideas why this is still screwing up?