Lua Gesior shop system!

[tommy91]

Help me please! I am trying to get my shop on the website working!
But i am getting this error:

Message: Unknown column 'itemid' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `type`, `itemid`, `count` FROM `z_ots_comunication` WHERE `account_id` = 8 LIMIT 1;

I am doing !shop but it says that i have no order and i have an order :/

 

[tommy91]

I have this in my Transaction:
GOD Furion

Your account Blade of Corruption 11 January 2017, 14:57:56 Not realized yet.

 

[Znote]

You have a table in your database called z_ots_comunication, this table is missing the data column named itemid.

 

[tommy91]

Oh, hmm, how do i add that column?

 

[Taurus]

Oh, hmm, how do i add that column?

There is a query with the shop system you are using that you must run in SQL before those columns will exist.

I'm CERTAIN no one would release a shop system without giving you the query. Look over the instructions for the shop system carefully. All you should have to do is run the query and you should be good!

Good luck, let us know how it's going! OR if you can't find it, you should probably link us to the place where you got your shop system.

 

[tommy91]

Well, https://otland.net/threads/gesior2012-items-shop-installation-administration.170654/

I cant really see a SQL query in there :/

 

[Taurus]

Well, https://otland.net/threads/gesior2012-items-shop-installation-administration.170654/

I cant really see a SQL query in there :/

So you are DEFINITELY using TFS 0.3/0.4? (Because you're right, they didn't include the query to create the column.)

 

[tommy91]

No, i am doin tfs 1.2 i think, Tibia 10.93 client.
Maybe its just me being stupid or something

 

[tommy91]

https://otland.net/threads/gesior-acc-shop-system-v-1-1.228338/
I am trying this one too. And no success

 

[Taurus]

Yeah, the system you are using is made for TFS 0.3/0.4 which have those columns included, I'm pretty sure.

One of these other guys might be able to write you an SQL query that would add those tables. Sorry I can't be of further help. I can edit/reuse scripts, reproduce what I see... but writing a query isn't something I've ever attempted.

 

[tommy91]

Znote, Do you know the SQL query for it? I have been searching for it :/

 

[Znote]

I'm not sure, since it is itemid it should contain an integer. But not sure if it is required or not.

You could try this:

ALTER TABLE `z_ots_comunication` ADD `itemid` int(11) DEFAULT NULL;

 

[tommy91]

id name type action itemid count account_id param4 param5 param6 param7 delete_it

that is how it says, and ive added the count, account_id and itemid

 

[tommy91]

But previous when the items got into the z_ots_comunication, it would not do anything, i could not extract it to my player.
Then i added the stuff, the count, account_id and itemid.
Nothing gets into the table :/