[HELP] lottery SQL critical error

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   [HELP] lottery SQL critical error
elositocandela
CZ Newbie
elositocandela has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Feb 01, 2005
0.00 posts per day
Posts: 3
Points: 89
   
okay i tried to install the lottery mod but it i got this error after trying to install it can someone help me
phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'djaztec_platinum.CONFIG_TABLE' doesn't exist

SELECT * FROM CONFIG_TABLE

Line : 249
File : /home/djaztec/public_html/modules/Forums/common.php



Back to top Reply with quote
#2   re: [HELP] lottery SQL critical error
elositocandela
CZ Newbie
elositocandela has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Feb 01, 2005
0.00 posts per day
Posts: 3
Points: 89
   
can some one help me please



Back to top Reply with quote
#3   re: [HELP] lottery SQL critical error
fncool
CZ Super Newbie
 Codezwiz Site Donator
fncool has been a member for over 20 year's 20 Year Member
canada.gif
Age: 62
Gender: Male
Status: Offline
Joined: Dec 19, 2004
0.01 posts per day
Posts: 56
Points: 4,786
   
reread the install.txt, you didn't edit the includes/constants.php file as instructed




_________________
I'm only replying because I want those extra 22.52 points!
Back to top Reply with quote
#4   re: [HELP] lottery SQL critical error
elositocandela
CZ Newbie
elositocandela has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Feb 01, 2005
0.00 posts per day
Posts: 3
Points: 89
   
OMFG the file u just toll me didnt have any code at all jeje i had to put it good thing i had a backup thanks any wasy



Back to top Reply with quote
#5   re: [HELP] lottery SQL critical error
alexcroox
CZ Newbie
alexcroox has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Dec 20, 2005
0.00 posts per day
Posts: 17
Points: 570
   
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 nuke_users WHERE user_id='167'

Line : 184
File : lottery.php

this happens when the lottery countdown has finished.

what have i done wrong?



Back to top Reply with quote
#6   
pnclthnmstsh
CZ Active Member
pnclthnmstsh has been a member for over 20 year's 20 Year Member
usa.gif nevada.gif
Age: 53
Gender: Male
Website:
Status: Offline
Joined: Sep 17, 2004
0.04 posts per day
Posts: 267
Points: 13,641
   
Run this in phpMyadmin

ALTER TABLE nuke_users ADD `user_items` TEXT;

It's calling on a table that gets installed with the Shop mod




_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
#7   re: [HELP] lottery SQL critical error
alexcroox
CZ Newbie
alexcroox has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Dec 20, 2005
0.00 posts per day
Posts: 17
Points: 570
   
yer i dont actualy use shop mod btw.

I believe it happened because in lottery admin i selected item_pool as yes.

i have reverted it to no now, but ill try what you said.



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum