lottery mod error

[ayasha]

Your phpBB Version: 2.0.22
phpBB Type: Integramod 141
MODs: Yes
Your knowledge: Basic Knowledge
Board URL: http://www.graphicsplayhouse.com/forum

PHP Version:
MySQL Version:


What was done before the problem appeared?



What was done to try to solve the problem?




De.scription and Message

when the lottery link is clicked on i get this error

Error getting information from users table!

DEBUG MODE

SQL Error : 1054 Unknown column 'user_items' in 'field list'

SELECT `username`, `user_items` FROM phpbb_users WHERE user_id='2'

Line : 174
File : lottery.php

now, i don't have the item pool enabled for the lottery, and i am assuming this error has to do with that feature, any suggestions?

[Teelk]

The problem is that the MOD seems to be missing user_items from the db install .script. The problem being that I don't know offhand what kind of column it needs to be.

I'm assuming from the code that it should be a long string and we'll need to use varchar.

You can try this, if it does't work you can easily delete the column from your users table through phpmyadmin, and it shouldn't effect anything else anyway.

Code: Select all

ALTER TABLE `phpbb_users` ADD `user_item` VARCHAR( 100 ) NULL ;

[ayasha]

thanks Teelk, i ran that query, and will let you know if i have any problems with it.

[ayasha]

that did not help Teelk, i am still getting the same error <img>

[Teelk]

That's because I'm an idiot and gave you sql code with user_item instead of user_items...

Go into phpmyadmin and rename user_item to user_items in the users table.

[ayasha]

well, i must be an idiot too then Teelk, because i kept reading over the error and reading over the sql code, and i did not notice it either <img>

thanks guy

[DjPorkchop]

I had that very same error when i installed it on 1.4.0 and there was a fix for it BUT i cant for the life of me remember where I found it. If you have the shop mod installed you will not get that error. Or shouldnt atleast. Let me do some digging too Cleo and if Teelks sql works great. If not Ill keep looking for that fix. i have it somewhere.

[Teelk]

Ah, ok then it should be the same as the ShopMOD's sql entry. Cleo, delete that column from the users table and run this query...

Code: Select all

ALTER TABLE phpbb_users add `user_items` TEXT;

Change the phpbb_ to your table prefix of coarse.

[ayasha]

ok, wait, i DO NOT have the shop mod installed....so which one should i use?

[Teelk]

The one from my last post.

[ayasha]

wanted to let you know Teelk, it is working good right now, thanks for your help <img>

[DjPorkchop]

Oh Ok.....Just forget about me Ms. Cleo ROFL!!!!!! J/K ya glad its working for you. <img>