Bad SubDomain SQL query! message.

[solostock.pl]

Hi

I would like to put subdomain in subdomain module, but I didn’t do it because I got Bad SubDomain SQL query! message.
After this my shop dead. I got only white screen and message Bad SubDomain SQL query!

please, can somebody help me, how to get back my shop ?

you can check http://www.solostock.pl

[Damien Metzger]

Enter both queries in MySQL (change the prefix ps_ for whatever you put) :

DROP TABLE IF EXISTS ps_subdomain;


CREATE TABLE ps_subdomain (
 id_subdomain INTEGER(10) NOT NULL AUTO_INCREMENT,
 name VARCHAR(16) NOT NULL,
 PRIMARY KEY(id_subdomain)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[solostock.pl]

Enter both queries in MySQL (change the prefix ps_ for whatever you put) :

DROP TABLE IF EXISTS ps_subdomain;


CREATE TABLE ps_subdomain (
 id_subdomain INTEGER(10) NOT NULL AUTO_INCREMENT,
 name VARCHAR(16) NOT NULL,
 PRIMARY KEY(id_subdomain)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Thanks for you reply , but I understand a little bit
What do you mean : "(change the prefix ps_ for whatever you put)"

I remember I was put "besttrade" as subdomain

look here my SQL history :

* chenge[`zyzol_solostock`] REPAIR TABLE `ps_subdomain`
* chenge[`zyzol_solostock`] CHECK TABLE `ps_subdomain`
* chenge[`zyzol_solostock`.`ps_subdomain`] SELECT * FROM `ps_subdomain`
* chenge[`zyzol_solostock`] SELECT COUNT(*) AS `count` FROM `zyzol_solostock`. [...] IKE '%subdomain%' OR `enabled` LIKE '%subdomain%')
* chenge[`zyzol_solostock`] SELECT COUNT(*) AS `count` FROM `zyzol_solostock`. [...] R `active` LIKE '%sub%' OR `enabled` LIKE '%sub%')
* chenge[`zyzol_solostock`] SELECT COUNT(*) AS `count` FROM `zyzol_solostock`. [...] R `active` LIKE '%www%' OR `enabled` LIKE '%www%')
* chenge[`zyzol_solostock`.`ps_connections`] SELECT * FROM `zyzol_solostock`.`ps_connections` [...] _add` LIKE '%www%' OR `http_referer` LIKE '%www%')
* chenge[`zyzol_solostock`] SELECT COUNT(*) AS `count` FROM `zyzol_solostock`. [...] IKE '

[Damien Metzger]

"zyzol_" is the prefix I was speaking of.
So you need to enter first

DROP TABLE IF EXISTS zyzol_subdomain;

then

CREATE TABLE zyzol_subdomain (
 id_subdomain INTEGER(10) NOT NULL AUTO_INCREMENT,
 name VARCHAR(16) NOT NULL,
 PRIMARY KEY(id_subdomain)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[solostock.pl]

"zyzol_" is the prefix I was speaking of.
So you need to enter first

DROP TABLE IF EXISTS zyzol_subdomain;

then

CREATE TABLE zyzol_subdomain (
 id_subdomain INTEGER(10) NOT NULL AUTO_INCREMENT,
 name VARCHAR(16) NOT NULL,
 PRIMARY KEY(id_subdomain)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I was enter exaclly you telling my, but I can't see any effects
Only I have a new cell in my database as name zyzol_subdomain , but the rest of my cells in database have names like PS_ xxxx (ps_prefix)

so is it ok to create a cell as name zyzol_subdomain ?

[solostock.pl]

"zyzol_" is the prefix I was speaking of.
So you need to enter first

DROP TABLE IF EXISTS zyzol_subdomain;

then

CREATE TABLE zyzol_subdomain (
 id_subdomain INTEGER(10) NOT NULL AUTO_INCREMENT,
 name VARCHAR(16) NOT NULL,
 PRIMARY KEY(id_subdomain)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I was enter exaclly you telling my, but I can't see any effects
Only I have a new cell in my database as name zyzol_subdomain , but the rest of my cells in database have names like PS_ xxxx (ps_prefix)

so is it ok to create a cell as name zyzol_subdomain ?

I remember also I was delete "www" domain in subdomain module


please help me