Jump to content
  • 0

MySQL Error


Boom

Question


  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.01
  • Content Count:  182
  • Reputation:   22
  • Joined:  12/30/12
  • Last Seen:  

Hi! I would like to ask if you know how could I solve this flux problem. This happens when I click the 'Checkout' link on the online item shop that Flux CP has built in.

 

Someone told me it's related to the PHPMyAdmin tables and there is a command to add the tables that are missing. I hope someone can enlighten me in how to go and input the command and what are the needed commands.

 

Thank you very much!

 

Capture.jpg

Link to comment
Share on other sites

4 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  35
  • Reputation:   1
  • Joined:  02/04/13
  • Last Seen:  

I show in my Database and i got these Table. If you delete this table here the  SQL Dump. 

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for cp_redeemlog
-- ----------------------------
DROP TABLE IF EXISTS `cp_redeemlog`;
CREATE TABLE `cp_redeemlog` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nameid` int(11) unsigned NOT NULL DEFAULT '0',
  `quantity` int(11) unsigned NOT NULL DEFAULT '0',
  `cost` int(11) unsigned NOT NULL,
  `account_id` int(11) unsigned NOT NULL,
  `char_id` int(11) unsigned DEFAULT NULL,
  `redeemed` tinyint(1) unsigned NOT NULL,
  `redemption_date` datetime DEFAULT NULL,
  `purchase_date` datetime NOT NULL,
  `credits_before` int(10) NOT NULL,
  `credits_after` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `nameid` (`nameid`,`account_id`,`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Log of redeemed donation items.';

-- ----------------------------
-- Records 
-- ----------------------------

Edited by ParSalian
Link to comment
Share on other sites


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2348
  • Joined:  10/28/11
  • Last Seen:  

just like what the error mentioned..

you dont have the SQL table named

 

cp_redeemlog
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.01
  • Content Count:  182
  • Reputation:   22
  • Joined:  12/30/12
  • Last Seen:  

just like what the error mentioned..

you dont have the SQL table named

 

cp_redeemlog

 

I don't know how to add tables though. MySQL Noob here. Help!  /ok

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.01
  • Content Count:  182
  • Reputation:   22
  • Joined:  12/30/12
  • Last Seen:  

Thanks guys!

Link to comment
Share on other sites

×
×
  • Create New...