Codezwiz >> Forums >> Codezwiz BBtoNuke Mods Help >> Forum Bookmakers Updated Version

I have that code in my includes/constants.php file

Register

Could you check your database just to make sure the installer did create a table called nuke_bookie_admin_bets.

I'm looking to see what else it could be but this hasn't occured on any installations yet.

Which installer did you use? That could help me track it down too. I tested each of them on a test site and had no errors.... but who knows....

I have nuke_bookie_bets & nuke_bookie_stats but no nuke_bookie_admin_bets

I also see a table called bookie_admin_bets but w/o the nuke in front.

On the install I used db_update_from_pre_202

Register

Ok, thanks..found the problem and fix the zip file too. If you would, go ahead and drop the table bookie_admin_bets and run this in your SQL

CREATE TABLE nuke_bookie_admin_bets (
bet_id int(11) NOT NULL auto_increment,
bet_time int(11) NOT NULL default '0',
bet_selection varchar(100) NOT NULL default ',
bet_meeting varchar(50) NOT NULL default ',
odds_1 int(11) NOT NULL default '0',
odds_2 int(11) NOT NULL default '0',
checked int(2) NOT NULL default '0',
multi int(11) NOT NULL default '-1',
KEY bet_id (bet_id)
);

Thanks ~ That table is created and the problem with the main index page is fixed.

These problems still left:
Main Bookies Page

Warning: main(modules/Forums/includes/page_header.php): failed to open stream: No such file or directory in /home/virtual/site155/fst/var/www/html/modules/Forums/bookies.php on line 52

Warning: main(): Failed opening 'modules/Forums/includes/page_header.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site155/fst/var/www/html/modules/Forums/bookies.php on line 52
General Error

Error in building base bets

DEBUG MODE

SQL Error : 1054 Unknown column 'bet_meeting' in 'order clause'

SELECT * FROM nuke_bookie_admin_bets WHERE multi=-1 AND bet_time>1107042442 AND checked=0 ORDER BY bet_time,bet_meeting DESC

Line : 334
File : /home/virtual/site155/fst/var/www/html/modules/Forums/bookies.php

Administration Links
Admin Set Bet

General Error
Error in building existing bet meetings

DEBUG MODE

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

SELECT bet_meeting,bet_time,bet_id FROM nuke_bookie_admin_bets WHERE multi=-1 AND checked=0 AND bet_time>'1107042592' ORDER BY bet_time,bet_meeting ASC

Line : 147
File : /home/virtual/site155/fst/var/www/html/modules/Forums/admin/admin_bookies_setbet.php

Bet Builder

General Error
Error in building existing bet meetings

DEBUG MODE

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

SELECT bet_meeting,bet_time,bet_id FROM nuke_bookie_admin_bets WHERE multi=-1 AND checked=0 AND bet_time>'1107042648' ORDER BY bet_time,bet_meeting ASC

Line : 65
File : /home/virtual/site155/fst/var/www/html/modules/Forums/admin/admin_bookies_multiple_bet.php

Process Bets

Warning: main(): Unable to access ../includes/functions_bookies.php in /home/virtual/site155/fst/var/www/html/modules/Forums/admin/admin_bookies.php on line 29

Warning: main(../includes/functions_bookies.php): failed to open stream: No such file or directory in /home/virtual/site155/fst/var/www/html/modules/Forums/admin/admin_bookies.php on line 29

Warning: main(): Failed opening '../includes/functions_bookies.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site155/fst/var/www/html/modules/Forums/admin/admin_bookies.php on line 29

General Error
Error in getting bets to build processing table

DEBUG MODE

SQL Error : 1054 Unknown column 'bet_meeting' in 'order clause'

SELECT * FROM nuke_bookie_admin_bets WHERE bet_time<'1107042688' AND checked=0 ORDER BY bet_time,bet_meeting DESC

Line : 602
File : /home/virtual/site155/fst/var/www/html/modules/Forums/admin/admin_bookies.php

Register

Replace line 52 in bookies.php with this

include('includes/page_header.'.$phpEx);

Delete line 29 in admin_bookies.php as I mentioned that line wasn't supposed to be included...not sure how it slipped by but its removed from the zip now.

The SQL errors are strange since you say you ran that snippet of code above to install that table. It certainly does include installing the column 'bet_meeting' that it says it cant find.

The warning errors are gone now but I'm still getting that SQL error about the Unknown column 'bet_meeting' in 'field list' ?

Register

Can you check to make sure that the column 'bet_meeting" does exist in "nuke_bookie_admin_bets" and if it doesn't run this in your SQL

ALTER TABLE nuke_bookie_admin_bets ADD bet_meeting varchar(50) NOT NULL;

That fixed it. Everything works on the admin side of it now.

The only error I am seeing is at the bottom of the bookies page:

Sorry, no bets available at the moment

Forum Bookmakers Mod 2.0.4 by Majorflam � 2004 Major Mod - Software Modifications For phpBB2

Warning: main(modules/Forums/includes/page_tail.php): failed to open stream: No such file or directory in /home/virtual/site155/fst/var/www/html/modules/Forums/bookies.php on line 585

Warning: main(): Failed opening 'modules/Forums/includes/page_tail.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site155/fst/var/www/html/modules/Forums/bookies.php on line 585

Register

edit line 585 in bookies.php from this

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

to this

include('includes/page_tail.'.$phpEx);

Sorry about the bad path..it worked on my site because of previous phpbb to nuke ports I've done and copied over page_tail to my modules/Forums/includes folder and overlooked this. I will fix this in the zip file ASAP.