myacc problem gift

[LoOoZa]

i get this problem in gift, im use tfs 1.3

 

[Loney]

Update your database. Table z_shop_categories does not exist. Or execute this SQL query:

CREATE TABLE IF NOT EXISTS `z_shop_category` (
    `id` int(11) NOT NULL ,
    `name` varchar(50) NOT NULL,
    `desc` varchar(255) NOT NULL,
    `button` varchar(50) NOT NULL,
    `hide` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

[LoOoZa]

Now this error!

 

[Ralumbi]

Insert this command into your SQL:

ALTER TABLE z_shop_category
ADD hidden int(11) NOT NULL DEFAULT '0';

Most likely will fix your issue.

 

[Yan18]

You can change de column name or clause where in Lua. You need to see what will better.

Change the query that Loney did to (run this query once):

DROP TABLE IF EXISTS `z_shop_category`;

CREATE TABLE IF NOT EXISTS `z_shop_category` (
    `id` int(11) NOT NULL ,
    `name` varchar(50) NOT NULL,
    `desc` varchar(255) NOT NULL,
    `button` varchar(50) NOT NULL,
    `hidden` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

[LoOoZa]

thanks work