Jump to content
  • 0

MySQL Error


Question

Posted

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

4 answers to this question

Recommended Posts

Posted (edited)

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
Posted

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

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...