dunno should post or not.. if not suppose.. mod can delete it..

error when i in main page..
There appears to be an error with the database.

Error Returned
mySQL query error: INSERT INTO ibf_cache_store (cs_array,cs_key,cs_value) VALUES(1,'badwords','a:26:{i:0;a:3:{s:4:"type";s:4:"f***";s:4:"swop";s:4:"f***";s:7:"m_exact";s:1:"0";}i:1;a:3:{s:4:"type";s:4:"d***";s:4:"swop";s:4:"d***";s:7:"m_exact";s:1:"1";}i:2;a:3:{s:4:"type";s:5:"b****";s:4:"swop";s:5:"b****";s:7:"m_exact";s:1:"0";}i:3;a:3:{s:4:"type";s:7:"*******";s:4:"swop";s:7:"*******";s:7:"m_exact";s:1:"1";}i:4;a:3:{s:4:"type";s:7:"*******";s:4:"swop";s:7:"*******";s:7:"m_exact";s:1:"1";}i:5;a:3:{s:4:"type";s:4:"p***";s:4:"swop";s:4:"p***";s:7:"m_exact";s:1:"1";}i:6;a:3:{s:4:"type";s:6:"p*";s:4:"swop";s:2:"p*";s:7:"m_exact";s:1:"1";}i:7;a:3:{s:4:"type";s:5:"*****";s:4:"swop";s:5:"*****";s:7:"m_exact";s:1:"1";}i:8;a:3:{s:4:"type";s:5:"*****";s:4:"swop";s:5:"*****";s:7:"m_exact";s:1:"1";}i:9;a:3:{s:4:"type";s:3:"***";s:4:"swop";s:3:"***";s:7:"m_exact";s:1:"1";}i:10;a:3:{s:4:"type";s:3:"***";s:4:"swop";s:3:"***";s:7:"m_exact";s:1:"1";}i:11;a:3:{s:4:"type";s:8:"********";s:4:"swop";s:8:"********";s:7:"m_exact";s:1:"1";}i:12;a:3:{s:4:"type";s:5:"LYN";s:4:"swop";s:3:"LYN";s:7:"m_exact";s:1:"1";}i:13;a:3:{s:4:"type";s:12:"<!--";s:4:"swop";s:18:"[bad html removed]";s:7:"m_exact";s:1:"1";}i:14;a:3:{s:4:"type";s:13:"[removed]";s:4:"swop";s:9:"[removed]";s:7:"m_exact";s:1:"1";}i:15;a:3:{s:4:"type";s:17:"[removed]";s:4:"swop";s:9:"[removed]";s:7:"m_exact";s:1:"1";}i:16;a:3:{s:4:"type";s:9:"[removed]";s:4:"swop";s:9:"[removed]";s:7:"m_exact";s:1:"0";}i:17;a:3:{s:4:"type";s:4:"****";s:4:"swop";s:4:"****";s:7:"m_exact";s:1:"1";}i:18;a:3:{s:4:"type";s:10:"flying spaghetti monster";s:4:"swop";s:24:"flying spaghetti monster";s:7:"m_exact";s:1:"1";}i:19;a:3:{s:4:"type";s:5:"?flyingspaghettimonster=";s:4:"swop";s:24:"?flyingspaghettimonster=";s:7:"m_exact";s:1:"0";}i:20;a:3:{s:4:"type";s:13:"spam.link.removed";s:4:"swop";s:17:"spam.link.removed";s:7:"m_exact";s:1:"0";}i:21;a:3:{s:4:"type";s:8:"flying spaghetti monster";s:4:"swop";s:24:"flying spaghetti monster";s:7:"m_exact";s:1:"0";}i:22;a:3:{s:4:"type";s:6:"flying spaghetti monster";s:4:"swop";s:24:"flying spaghetti monster";s:7:"m_exact";s:1:"0";}i:23;a:3:{s:4:"type";s:7:"lowyat";s:4:"swop";s:6:"lowyat";s:7:"m_exact";s:1:"0";}i:24;a:3:{s:4:"type";s:8:"giant hamster in the sky";s:4:"swop";s:24:"giant hamster in the sky";s:7:"m_exact";s:1:"1";}i:25;a:3:{s:4:"type";s:4:"<no spam links>";s:4:"swop";s:21:"&lt;no spam links&gt;";s:7:"m_exact";s:1:"0";}}')

mySQL error: Duplicate entry 'badwords' for key 1
mySQL error code:
Date: Monday 25th of September 2006 02:14:56 PM


error while i in http://forum.lowyat.net/index.php?showtopic=343157&st=40

mySQL query error: INSERT INTO ibf_cache_store (cs_array,cs_key,cs_value) VALUES(1,'emoticons','a:75:{i:0;a:4:{s:5:"typed";s:8:":mellow:";s:5:"image";s:10:"mellow.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:1;a:4:{s:5:"typed";s:5:":huh:";s:5:"image";s:7:"huh.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:2;a:4:{s:5:"typed";s:3:"^_^";s:5:"image";s:9:"happy.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:3;a:4:{s:5:"typed";s:5:":omg:";s:5:"image";s:8:"ohmy.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:4;a:4:{s:5:"typed";s:2:";)";s:5:"image";s:8:"wink.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:5;a:4:{s:5:"typed";s:2:":P";s:5:"image";s:10:"tongue.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:6;a:4:{s:5:"typed";s:2:":D";s:5:"image";s:11:"biggrin.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:7;a:4:{s:5:"typed";s:5:":lol:";s:5:"image";s:9:"laugh.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:8;a:4:{s:5:"typed";s:2:"B]";s:5:"image";s:8:"cool.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:9;a:4:{s:5:"typed";s:10:":rolleyes:";s:5:"image";s:12:"rolleyes.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:10;a:4:{s:5:"typed";s:3:"-_-";s:5:"image";s:9:"sleep.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:11;a:4:{s:5:"typed";s:9:"&lt;_&lt;";s:5:"image";s:7:"dry.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:12;a:4:{s:5:"typed";s:2:":)";s:5:"image";s:9:"smile.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:13;a:4:{s:5:"typed";s:5:":wub:";s:5:"image";s:7:"wub.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:14;a:4:{s:5:"typed";s:7:":angry:";s:5:"image";s:7:"mad.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:15;a:4:{s:5:"typed";s:2:":(";s:5:"image";s:7:"sad.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:16;a:4:{s:5:"typed";s:8:":unsure:";s:5:"image";s:10:"unsure.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:17;a:4:{s:5:"typed";s:7:":wacko:";s:5:"image";s:9:"wacko.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:18;a:4:{s:5:"typed";s:7:":blink:";s:5:"image";s:9:"blink.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:19;a:4:{s:5:"typed";s:7:":freak:";s:5:"image";s:9:"ph34r.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:20;a:4:{s:5:"typed";s:9:":respect:";s:5:"image";s:13:"notworthy.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:21;a:4:{s:5:"typed";s:8:":thumbs:";s:5:"image";s:11:"thumbup.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:22;a:4:{s:5:"typed";s:2:":w";s:5:"image";s:13:"whistling.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:23;a:4:{s:5:"typed";s:6:":oops:";s:5:"image";s:8:"oops.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:24;a:4:{s:5:"typed";s:6:":flex:";s:5:"image";s:8:"flex.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:25;a:4:{s:5:"typed";s:7:":drool:";s:5:"image";s:9:"drool.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:26;a:4:{s:5:"typed";s:2:":o";s:5:"image";s:8:"yawn.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:27;a:4:{s:5:"typed";s:7:":sweat:";s:5:"image";s:9:"sweat.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:28;a:4:{s:5:"typed";s:2:":x";s:5:"image";s:7:"doh.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:29;a:4:{s:5:"typed";s:7:":shock:";s:5:"image";s:12:"shocking.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:30;a:4:{s:5:"typed";s:7:":blush:";s:5:"image";s:9:"blush.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:31;a:4:{s:5:"typed";s:6:":lust:";s:5:"image";s:8:"lust.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:32;a:4:{s:5:"typed";s:5:":nod:";s:5:"image";s:7:"nod.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:33;a:4:{s:5:"typed";s:7:":bruce:";s:5:"image";s:9:"bruce.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:34;a:4:{s:5:"typed";s:11:":shakehead:";s:5:"image";s:13:"shakehead.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:35;a:4:{s:5:"typed";s:6:":hehe:";s:5:"image";s:9:"brows.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:36;a:4:{s:5:"typed";s:5:":dob:";s:5:"image";s:8:"bday.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:37;a:4:{s:5:"typed";s:7:":party:";s:5:"image";s:9:"party.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:38;a:4:{s:5:"typed";s:8:":$:";s:5:"image";s:14:"moneyflies.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:39;a:4:{s:5:"typed";s:9:":grumble:";s:5:"image";s:11:"grumble.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:40;a:4:{s:5:"typed";s:6:":xmas:";s:5:"image";s:8:"xmas.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:41;a:4:{s:5:"typed";s:5:":cry:";s:5:"image";s:7:"cry.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:42;a:4:{s:5:"typed";s:6:":wave:";s:5:"image";s:8:"wave.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:43;a:4:{s:5:"typed";s:9:":furious:";s:5:"image";s:8:"vmad.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:44;a:4:{s:5:"typed";s:2:":D";s:5:"image";s:11:"biggrin.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:45;a:4:{s:5:"typed";s:2:":P";s:5:"image";s:10:"tongue.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:46;a:4:{s:5:"typed";s:2:"8)";s:5:"image";s:8:"cool.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:47;a:4:{s:5:"typed";s:7:":laugh:";s:5:"image";s:9:"laugh.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:48;a:4:{s:5:"typed";s:10:":rolleyes:";s:5:"image";s:12:"rolleyes.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:49;a:4:{s:5:"typed";s:7:":sleep:";s:5:"image";s:9:"sleep.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:50;a:4:{s:5:"typed";s:7:":happy:";s:5:"image";s:9:"happy.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:51;a:4:{s:5:"typed";s:5:":huh:";s:5:"image";s:7:"huh.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:52;a:4:{s:5:"typed";s:8:":mellow:";s:5:"image";s:10:"mellow.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:53;a:4:{s:5:"typed";s:6:":ohmy:";s:5:"image";s:8:"ohmy.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:54;a:4:{s:5:"typed";s:2:";)";s:5:"image";s:8:"wink.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:55;a:4:{s:5:"typed";s:2:":)";s:5:"image";s:9:"smile.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:56;a:4:{s:5:"typed";s:5:":wub:";s:5:"image";s:7:"wub.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:57;a:4:{s:5:"typed";s:7:":blink:";s:5:"image";s:9:"blink.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:58;a:4:{s:5:"typed";s:2:":@";s:5:"image";s:7:"mad.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:59;a:4:{s:5:"typed";s:7:":ph34r:";s:5:"image";s:9:"ph34r.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:60;a:4:{s:5:"typed";s:2:":(";s:5:"image";s:7:"sad.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:61;a:4:{s:5:"typed";s:8:":unsure:";s:5:"image";s:10:"unsure.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:62;a:4:{s:5:"typed";s:2:":S";s:5:"image";s:9:"wacko.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:6:"subway";}i:63;a:4:{s:5:"typed";s:6:":clap:";s:5:"image";s:10:"rclxms.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:6:"subway";}i:64;a:4:{s:5:"typed";s:8:":cheers:";s:5:"image";s:10:"cheers.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:65;a:4:{s:5:"typed";s:7:":peace:";s:5:"image";s:17:"icon_rolleyes.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:66;a:4:{s:5:"typed";s:6:":clap:";s:5:"image";s:10:"rclxms.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:67;a:4:{s:5:"typed";s:7:":stars:";s:5:"image";s:10:"rclxub.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:68;a:4:{s:5:"typed";s:6:":idea:";s:5:"image";s:13:"icon_idea.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:69;a:4:{s:5:"typed";s:6:":help:";s:5:"image";s:17:"icon_question.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:70;a:4:{s:5:"typed";s:8:":tongue:";s:5:"image";s:10:"rclxs0.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:71;a:4:{s:5:"typed";s:7:":sucks:";s:5:"image";s:10:"rclxlh.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:72;a:4:{s:5:"typed";s:4:":OT:";s:5:"image";s:12:"sign0006.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}i:73;a:4:{s:5:"typed";s:7:":hyper:";s:5:"image";s:10:"rclxm9.gif";s:9:"clickable";s:1:"1";s:7:"emo_set";s:7:"default";}i:74;a:4:{s:5:"typed";s:6:":spam:";s:5:"image";s:12:"sign0014.gif";s:9:"clickable";s:1:"0";s:7:"emo_set";s:7:"default";}}')

mySQL error: Duplicate entry 'emoticons' for key 1
mySQL error code:
Date: Monday 25th of September 2006 02:13:55 PM


fyi. i using opera

use firefox then =X

No worries. It's because the forum wasn't written to be transaction-safe.

I have changed those queries from a two-step "DELETE ... INSERT ..." (where concurrency issues can arise) to a "REPLACE INTO ...". This problem shouldn't appear anymore.