Bug Strange Database Errors

[Diana Notacat]

Having some strange database errors. Right now it's when trying to add a new species. We fill out everything then "add species" and get the error. But before I can see what the error actually IS the entire browser locks up and crashes. The emailed error message comes back with a "REPLACE INTO datastore" as the culprit!

I tried to reupload everything and go through the upgrade/installation just in case I missed something. Tried add species again, and this time it told me the species already existed (even though it wasn't appearing in the list.) THEN I went to "Repair Cache" got that same database error & crash, and same error email from datastore!

So I am assuming something with updating the datastore is borked. D:

Don't know if this is related but:
4. Import the forumon-export.xml file from the "XML" folder at forumonadmin.php -> Import / Export- > Import.

I couldn't complete this step in the installation/upgrade because that file doesn't exist in the 1.0.4 pro package.

 

[Fillip H.]

Please provide the full error message.

Also, we're aware that step is currently unpossible to complete, Cosmic is working on it

 

[Diana Notacat]

This was the reason I didn't post the entire error message. XD It just goes on and on and on and on. This isn't the full one either, it's just a partial paste from the email. Even THAT is clipped with a "view full message" thing cause gmail couldn't load it all. x__x

Database error in vBulletin 4.1.0:

Invalid SQL:

REPLACE INTO datastore
(title, data, unserialize)
VALUES
('dbtech_forumon_species', 'a:5:{i:1;a:15:{s:9:\"speciesid\";s:1:\"1\";s:5:\"title\";s:5:\"Rocky\";s:11:\"description\";s:20:\"Likes to throw rocks\";s:6:\"active\";s:1:\"1\";s:9:\"levelrate\";s:448057:\"a:2:{s:6:\\\"config\\\";a:2:{s:8:\\\"startexp\\\";s:2:\\\"25\\\";s:8:\\\"increase\\\";s:2:\\\"10\\\";}s:6:\\\"levels\\\";a:4999:{i:1;s:2:\\\"25\\\";i:2;d:28;i:3;d:31;i:4;d:34;i:5;d:37;i:6;d:41;i:7;d:45;i:8;d:50;i:9;d:55;i:10;d:61;i:11;d:67;i:12;d:74;i:13;d:81;i:14;d:89;i:15;d:98;i:16;d:108;i:17;d:119;i:18;d:131;i:19;d:144;i:20;d:158;i:21;d:174;i:22;d:191;i:23;d:210;i:24;d:231;i:25;d:254;i:26;d:279;i:27;d:307;i:28;d:338;i:29;d:372;i:30;d:409;i:31;d:450;i:32;d:495;i:33;d:545;i:34;d:600;i:35;d:660;i:36;d:726;i:37;d:799;i:38;d:879;i:39;d:967;i:40;d:1064;i:41;d:1170;i:42;d:1287;i:43;d:1416;i:44;d:1558;i:45;d:1714;i:46;d:1885;i:47;d:2074;i:48;d:2281;i:49;d:2509;i:50;d:2760;i:51;d:3036;i:52;d:3340;i:53;d:3674;i:54;d:4041;i:55;d:4445;i:56;d:4890;i:57;d:5379;i:58;d:5917;i:59;d:6509;i:60;d:7160;i:61;d:7876;i:62;d:8664;i:63;d:9530;i:64;d:10483;i:65;d:11531;i:66;d:12684;i:67;d:13952;i:68;d:15347;i:69;d:16882;i:70;d:18570;i:71;d:20427;i:72;d:22470;i:73;d:24717;i:74;d:27189;i:75;d:29908;i:76;d:32899;i:77;d:36189;i:78;d:39808;i:79;d:43789;i:80;d:48168;i:81;d:52985;i:82;d:58284;i:83;d:64112;i:84;d:70523;i:85;d:77575;i:86;d:85333;i:87;d:93866;i:88;d:103253;i:89;d:113578;i:90;d:124936;i:91;d:137430;i:92;d:151173;i:93;d:166290;i:94;d:182919;i:95;d:201211;i:96;d:221332;i:97;d:243465;i:98;d:267812;i:99;d:294593;i:100;d:324052;i:101;d:356457;i:102;d:392103;i:103;d:431313;i:104;d:474444;i:105;d:521888;i:106;d:574077;i:107;d:631485;i:108;d:694634;i:109;d:764097;i:110;d:840507;i:111;d:924558;i:112;d:1017014;i:113;d:1118715;i:114;d:1230587;i:115;d:1353646;i:116;d:1489011;i:117;d:1637912;i:118;d:1801703;i:119;d:1981873;i:120;d:2180060;i:121;d:2398066;i:122;d:2637873;i:123;d:2901660;i:124;d:3191826;i:125;d:3511009;i:126;d:3862110;i:127;d:4248321;i:128;d:4673153;i:129;d:5140468;i:130;d:5654515;i:131;d:6219967;i:132;d:6841964;i:133;d:7526160;i:134;d:8278776;i:135;d:9106654;i:136;d:10017319;i:137;d:11019051;i:138;d:12120956;i:139;d:13333052;i:140;d:14666357;i:141;d:16132993;i:142;d:17746292;i:143;d:19520921;i:144;d:21473013;i:145;d:23620314;i:146;d:25982345;i:147;d:28580580;i:148;d:31438638;i:149;d:34582502;i:150;d:38040752;i:151;d:41844827;i:152;d:46029310;i:153;d:50632241;i:154;d:55695465;i:155;d:61265012;i:156;d:67391513;i:157;d:74130664;i:158;d:81543730;i:159;d:89698103;i:160;d:98667913;i:161;d:108534704;i:162;d:119388174;i:163;d:131326991;i:164;d:144459690;i:165;d:158905659;i:166;d:174796225;i:167;d:192275848;i:168;d:211503433;i:169;d:232653776;i:170;d:255919154;i:171;d:281511069;i:172;d:309662176;i:173;d:340628394;i:174;d:374691233;i:175;d:412160356;i:176;d:453376392;i:177;d:498714031;i:178;d:548585434;i:179;d:603443977;i:180;d:663788375;i:181;d:730167213;i:182;d:803183934;i:183;d:883502327;i:184;d:971852560;i:185;d:1069037816;i:186;d:1175941598;i:187;d:1293535758;i:188;d:1422889334;i:189;d:1565178267;i:190;d:1721696094;i:191;d:1893865703;i:192;d:2083252273;i:193;d:2291577500;i:194;d:2520735250;i:195;d:2772808775;i:196;d:3050089653;i:197;d:3355098618;i:198;d:3690608480;i:199;d:4059669328;i:200;d:4465636261;i:201;d:4912199887;i:202;d:5403419876;i:203;d:5943761864;i:204;d:6538138050;i:205;d:7191951855;i:206;d:7911147041;i:207;d:

 

[Fillip H.]

My guess is it's talking about packet size. You'd need to increase the max_allowed_packet in your my.cnf file and then restart MySQL.

If not, then I need the bottom part of it, the one that prints an error number and an actual error message

 

[Diana Notacat]

I'mma need an email addy to forward it to, then, cause I can't get the dang email to load the full thing in my browser so I can even see the bottom. o______o

 

[Fillip H.]

Email sent in PM

 

[Diana Notacat]

Email forwarded, sorry that took so long. >< Having one of those long weeks.

 

[Fillip H.]

It said [message clipped]

My guess is it's talking about packet size. You'd need to increase the max_allowed_packet in your my.cnf file and then restart MySQL.

 

[Diana Notacat]

I shall harass my hostman and try some things. D:

 

[Diana Notacat]

Just as an update, I have it working fine now without having to contact my host about changes. I think something got borked during the Lite to Pro conversion. D: After I uninstalled and then reinstalled with Pro everything is now working fine.

 

[Cosmic]

Thanks for the update ^.^