storage problem

[untouchable]

[26/10/2009 08:01:34] > WARNING: max_allowed_packet might be set too low for binary map storage.
[26/10/2009 08:01:34] Use the following query to raise max_allow_packet: SET GLOBAL max_allowed_packet = 16776192;

server works and everything like after couples hours around 6-8 hours online it crashes anybody know why says that global thing and how to fix thanks

 

[Bam]

Go into your phpmyadmin, press the SQL button and put in

SET GLOBAL max_allowed_packet = 16776192

then press run

 

[untouchable]

Thanks i give you rep now i gota another problem i made a website and new comers cant make there characters they can make there accounts here example whats it saying

 The Following  errors Have Occurred:
# Wrong characters configuration. Try again or contact with admin. ADMIN:  edit file config/config.php and set valid characters to copy names. Character to copyDruid Sample doesn't exist.

 

[Bam]

Oh, you dont have any sample characters? Like Druid Sample, Sorcerer Sample on your admin account?

 

[untouchable]

i dleted them by accident :S didint know i needed them

 

[Bam]

then re-upload ur database..

The samples are for the character creations

If you put level 8 on all ur samples and some items, that means that whenever a person creates that vocation (for instance druid) they will get all lvl skills and items that druid sample got

 

[untouchable]

you meen i have to delete my current database and reload it again

 

[untouchable]

ok i reloaded my database but my web is not there and i cant get in look what it says

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rlname' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:229 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\index.php(27): OTS_Account->load('1') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 229

i tried to find line 229 but says (line number out of range)

any ideas????? ill repp++++

 

[Valania]

ok i reloaded my database but my web is not there and i cant get in look what it says

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rlname' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:229 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\index.php(27): OTS_Account->load('1') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 229

i tried to find line 229 but says (line number out of range)

any ideas????? ill repp++++

ALTER TABLE `accounts` ADD `rlname` VARCHAR(32) NOT NULL DEFAULT '0';

Rep me++

 

[untouchable]

ALTER TABLE `accounts` ADD `rlname` VARCHAR(32) NOT NULL DEFAULT '0';

Rep me++

where do i put the code?