PDA

View Full Version : Icon SQL Error


devace
09-17-2009, 02:34 AM
Hello Guys, I'm posting today on behalf of a Icon SQL Error, Ok Let's get straight to the story..
I installed the VB board using my ip as the website address, Just temporally until i got my website and well now that i have gotton my website, i finally finished transferring all the folders and the SQL to phpmyadmin, I have recently have been getting icon errors, No Post icons will show up, And yes i changed the paths to them.. Well below is a picture of the error, i was using VBAdvanced to check the paths, as well as the Post Icon Manager in AdminCP...

Heres the error:
http://i458.photobucket.com/albums/qq304/acexminey/Aceban/sqlerror.jpg
Heres the error in the script its self:

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT COUNT(*) AS count FROM icon WHERE iconpath NOT LIKE 'http://REMOVED.COM%';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, September 17th 2009 @ 12:47:57 AM
Error Date : Thursday, September 17th 2009 @ 12:48:58 AM
Script : http://REMOVED.COM/admincp/vbacmps_install.php
Referrer : http://REMOVED.COM/admincp/vbacmps_install.php
IP Address : REMOVED
Username : REMOVED
Classname : vB_Database
MySQL Version :
If you can help it will be greatly appreciated.
Thanks,
DevAce

CareyCrew
09-17-2009, 05:33 AM
An incorrect icon path is not going to cause a Mysql error as far as I know.

Error 2006 refers to max allowed packets

max_allowed_packet is a server option which needs to be set in the
[mysqld] section of /etc/my.cnf, not specified to the 'mysql' client
on the command line like you're trying. But generally you're going
in the right direction - the "MySQL server has gone away" error is
caused by a query longer than the max_allowed_packet.

Our Sponsors
 

devace
09-17-2009, 05:38 AM
so how would i fix that though? (*Sorry for the noob question*)

Brian
09-17-2009, 11:33 AM
That's an issue that you would need to contact your host about.