Guest Posted August 21, 2006 Share Posted August 21, 2006 I upgraded to 3.0.12 and everything seems to be ok until I turn on spam bot for tell a friend and I get the following error. MySQL Error Occured 1146: Table 'DATABASENAME.ar4ccCubeCart_SpamBot' doesn't exist QUERY = INSERT INTO ar4ccCubeCart_SpamBot (`uniqueId`, `time`, `spamCode`, `userIp`) VALUES ('068fa671997d384833ed459f04e757e4', '1156198891', 'PYR0UGVL', '86.138.141.28') If I turn spambot off I can enter the info but when I go to submit I get the following... MySQL Error Occured 1146: Table 'DATABASENAME.ar4ccCubeCart_SpamBot' doesn't exist QUERY = SELECT SpamCode, userIp FROM ar4ccCubeCart_SpamBot WHERE uniqueId = '' Any thoughts as to why this is happening? Quote Link to comment Share on other sites More sharing options...
Guest Kristina Posted August 22, 2006 Share Posted August 22, 2006 I upgraded to 3.0.12 and everything seems to be ok until I turn on spam bot for tell a friend and I get the following error. MySQL Error Occured 1146: Table 'DATABASENAME.ar4ccCubeCart_SpamBot' doesn't exist QUERY = INSERT INTO ar4ccCubeCart_SpamBot (`uniqueId`, `time`, `spamCode`, `userIp`) VALUES ('068fa671997d384833ed459f04e757e4', '1156198891', 'PYR0UGVL', '86.138.141.28') If I turn spambot off I can enter the info but when I go to submit I get the following... MySQL Error Occured 1146: Table 'DATABASENAME.ar4ccCubeCart_SpamBot' doesn't exist QUERY = SELECT SpamCode, userIp FROM ar4ccCubeCart_SpamBot WHERE uniqueId = '' Any thoughts as to why this is happening? Sounds like the sql command didn't create the database when you upgraded. If you used the script, try running the sql command manually. You can find it in the upgrade files. Copy it from the file, then open up in your sql editor, such as, phpmyadmin. You should find that in your web host control panel. Click on your database. Then click on Sql. Paste the code in and hit go/enter. It should create the database. Kristina Quote Link to comment Share on other sites More sharing options...
Guest Posted August 22, 2006 Share Posted August 22, 2006 I shall give it a go tonight and see what happens. Quote Link to comment Share on other sites More sharing options...
Guest Posted August 22, 2006 Share Posted August 22, 2006 Kristina, Thanks - that seems to have worked. If I've any more problems I'll post here. I just need to check that it all works! Euan Quote Link to comment Share on other sites More sharing options...
Guest apertureboy Posted August 31, 2006 Share Posted August 31, 2006 Hi, Just wondering if someone can help with the tell a friend: I get this when spambot is not enabled and hit the send button. When spambot is enabled I get the same message but cant even see the form. -------------------------------------- MySQL Error Occured 1146: Table 'bodhispi_ccrt1.CubeCart_SpamBot' doesn't exist QUERY = SELECT SpamCode, userIp FROM CubeCart_SpamBot WHERE uniqueId = '' --------------------------------------- I ran the sql query in PhpMyAdmin as suggested above: --------------------------------------- CREATE TABLE `{PREFIX}CubeCart_SpamBot` (`uniqueId` varchar(32) NOT NULL, `spamCode` varchar(5) NOT NULL, `userIp` varchar(15) NOT NULL,`time` int(10) NOT NULL default '0', PRIMARY KEY (`uniqueId`), UNIQUE KEY `uniqueId` (`uniqueId`) ) TYPE=MyISAM --------------------------------------- Was I supposed to change {PREFIX}? Any thoughts would be greatly appreciated. Thx Rob Kristina, Thanks - that seems to have worked. If I've any more problems I'll post here. I just need to check that it all works! Euan Quote Link to comment Share on other sites More sharing options...
Guest Enterprize Posted September 14, 2006 Share Posted September 14, 2006 Fantastic, did a manual addition of table (first use of sql) and all works great. Ian www.health-wellbeing.co.uk Thanks Hi, Just wondering if someone can help with the tell a friend: I get this when spambot is not enabled and hit the send button. When spambot is enabled I get the same message but cant even see the form. -------------------------------------- MySQL Error Occured 1146: Table 'bodhispi_ccrt1.CubeCart_SpamBot' doesn't exist QUERY = SELECT SpamCode, userIp FROM CubeCart_SpamBot WHERE uniqueId = '' --------------------------------------- I ran the sql query in PhpMyAdmin as suggested above: --------------------------------------- CREATE TABLE `{PREFIX}CubeCart_SpamBot` (`uniqueId` varchar(32) NOT NULL, `spamCode` varchar(5) NOT NULL, `userIp` varchar(15) NOT NULL,`time` int(10) NOT NULL default '0', PRIMARY KEY (`uniqueId`), UNIQUE KEY `uniqueId` (`uniqueId`) ) TYPE=MyISAM --------------------------------------- Was I supposed to change {PREFIX}? Any thoughts would be greatly appreciated. Thx Rob Kristina, Thanks - that seems to have worked. If I've any more problems I'll post here. I just need to check that it all works! Euan Quote Link to comment Share on other sites More sharing options...
Guest Kristina Posted September 14, 2006 Share Posted September 14, 2006 Hi, Just wondering if someone can help with the tell a friend: I get this when spambot is not enabled and hit the send button. When spambot is enabled I get the same message but cant even see the form. -------------------------------------- MySQL Error Occured 1146: Table 'bodhispi_ccrt1.CubeCart_SpamBot' doesn't exist QUERY = SELECT SpamCode, userIp FROM CubeCart_SpamBot WHERE uniqueId = '' --------------------------------------- I ran the sql query in PhpMyAdmin as suggested above: --------------------------------------- CREATE TABLE `{PREFIX}CubeCart_SpamBot` (`uniqueId` varchar(32) NOT NULL, `spamCode` varchar(5) NOT NULL, `userIp` varchar(15) NOT NULL,`time` int(10) NOT NULL default '0', PRIMARY KEY (`uniqueId`), UNIQUE KEY `uniqueId` (`uniqueId`) ) TYPE=MyISAM --------------------------------------- Was I supposed to change {PREFIX}? Any thoughts would be greatly appreciated. Thx Rob Kristina, Thanks - that seems to have worked. If I've any more problems I'll post here. I just need to check that it all works! Euan Yes, you either need to delete it if there is no prefix or you need to change it to your prefix. If you look in phpMyAdmin from your website control panel, you should be able to see the database and look at the other modules. If there is a prefix in front of them you want to add it where it says prefix, if there isn't just delete the {PREFIX} Kristina Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.