PDA

View Full Version : Error message "SQL Server's error"


Ioannis Freris
04-15-2007, 06:47 PM
a) I am getting error message after upgrading to 2.1.02
http://www.guideofweb.com

SQL Server's error: MySQL server has gone away

SQL Query: SELECT * FROM v2102_admins WHERE `id`='1' LIMIT 0,1

b) Most of the options in admin mode are duplicate

c) I dont get an e-mail informing me that New site was added
:(

Sergey Ten
04-16-2007, 04:04 AM
Hello Ioannis,

#1 It is not related to eSyndiCat script. Try to contact with your hosting company.

#2 Try to run this query via admin panel of the eSydniCat:


DELETE FROM `your_prefix_config` WHERE `id` > '204'


#3 Please check up your email configuration.

Ioannis Freris
04-16-2007, 07:26 PM
b) i tried it and i get the same message

The funny thing is,that if someone tried to add a link, the database accepts it.
the same happends when i add a link from admin mode.

Sergey Ten
04-17-2007, 04:15 AM
Hello Ioannis,

Please post URL you site.

Ioannis Freris
04-17-2007, 06:14 PM
Its on the first message
www.guideofweb.com

Sergey Ten
04-18-2007, 05:00 AM
Hello Ioannis Freris,

Please check up your PM.

Ioannis Freris
04-25-2007, 12:52 PM
I cant see the categories in the 1rst page
www.guideofweb.com

But i can see them from popular / top / random

I didnt change anything, i just received a big amount of new links

Sergey Ten
04-25-2007, 02:17 PM
Hello Ioannis Freris,

Run this query via admin panel of eSyndiCat:


DELETE FROM `your_prefix_categories` WHERE `title` = 'ROOT' AND `id` > '0';

Ioannis Freris
04-25-2007, 02:42 PM
Query Failed:
Table '***********.your_prefix_categories' doesn't exist

Sergey Ten
04-26-2007, 04:19 AM
Hello Ioannis,

You have to replace "your_prefix" to your real table prefix.

Ioannis Freris
05-15-2007, 10:19 AM
I must be doing something wrong.

If my tables are go_categories , go_buttons...
I should try the following, am i correct?

DELETE FROM `go_` WHERE `title` = 'ROOT' AND `id` > '0';

but i get the following error:
Query Failed:
Table 'username_database.go_' doesn't exist

Sergey Ten
05-15-2007, 10:27 AM
Hello Ioannis

For example you have such tables in the database:


v21_categories
v21_links
v21_link_categories
etc..


The v21_ is table prefix.

Ioannis Freris
05-15-2007, 10:48 AM
I am doing the right thing, but i get
Query Failed:
Table doesn't exist

Sergey Ten
05-15-2007, 11:06 AM
Hello Ioannis,

Please send me your FTP details via PM.