or getting information from users table!

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
User avatar
miurdock
Registered User
Posts: 79
Joined: Sat Sep 24, 2005 9:30 am
Contact:

or getting information from users table!

Post by miurdock »

Code: Select all

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='9'

Line : 174
File : lottery.php 
what is wrong?
cybrid23
Former Team Member
Posts: 9877
Joined: Wed Jun 29, 2005 5:55 am
Location: Somewhere in the Midwest...
Contact:

Post by cybrid23 »

Well, since that is not a standard table, and that is not a standard phpbb file, you must have installed a Mod.

Did you remember to run the SQL queries for the Mod? Doesn't look like you did.

Check the Mod for the queries, or a php script to install the tables in your database.

Further support should be found where you obtained the Mod.
---Never leave home without a towel and your peril sensitive sunglasses.
---Do Not PM Me For Support. It will go unanswered.
Thanks.
User avatar
miurdock
Registered User
Posts: 79
Joined: Sat Sep 24, 2005 9:30 am
Contact:

Post by miurdock »

Yes, it is mod.
But I have made all SQL queries.

Code: Select all

CREATE TABLE `phpbb_lottery`
	(`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` INT (20) NOT NULL, PRIMARY KEY(`id`), INDEX(`user_id`));

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_cost', '1');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_ticktype', 'single');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_length', '500000');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_name', 'Lottery');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_base', '50');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_start', '0');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_reset', '0');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_status', '0');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_items', '0');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_win_items', '');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_show_entries', '0');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_mb', '0');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_mb_amount', '1');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_history', '1');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_currency', '');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_item_mcost', '1');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_item_xcost', '500');

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('lottery_random_shop', '');

CREATE TABLE `phpbb_lottery_history`
	(
		`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, 
		`user_id` INT (20) NOT NULL, 
		`amount` INT (20) NOT NULL, 
		`currency` CHAR (32) NOT NULL, 
		`time` INT (20) NOT NULL, PRIMARY KEY(`id`), INDEX(`user_id`)
	);
cybrid23
Former Team Member
Posts: 9877
Joined: Wed Jun 29, 2005 5:55 am
Location: Somewhere in the Midwest...
Contact:

Post by cybrid23 »

You are going to have to ask where you got the Mod. That table does not exist in your database, and it is not in those queries.

If you got the Mod here, then go to the thread for it in the Mod forum.

If you got it somewhere else, then you need to go there, or contact the author.
---Never leave home without a towel and your peril sensitive sunglasses.
---Do Not PM Me For Support. It will go unanswered.
Thanks.
User avatar
drathbun
Former Team Member
Posts: 12204
Joined: Thu Jun 06, 2002 3:51 pm
Location: TOPICS_TABLE
Contact:

Post by drathbun »

If my memory serves, the lottery MOD requires that the shop MOD be installed first. The Shop MOD creates the user_items field in the database. The Lottery MOD should have included a requirement for this...
I blog about phpBB: phpBBDoctor blog
Still using phpbb2? So am I! Click below for details
Image
User avatar
RMcGirr83
Former Team Member
Posts: 21696
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Post by RMcGirr83 »

Actually the ability to have the shop items part of the lottery is selectable in the ACP for this mod.

www.zarath.com/mods is the latest site of the author (and of this mod)...he regularly visits phpbbhacks.com
Locked

Return to “2.0.x Support Forum”