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.
vBulletin® v3.7.0, Copyright ©2000-2008, Jelsoft Enterprises Ltd.