Load time so far: 0.11 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;
Warning: Cannot modify header information - headers already sent by (output started at /home/builder/public_html/classes/database.php:244) in /home/builder/public_html/prestart.php on line 123
Load time so far: 0.12 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 23 for Resource id #31
Load time so far: 0.12 seconds. Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 4 for Resource id #33
Load time so far: 0.12 seconds. Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #34
Load time so far: 0.12 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
Number of rows is 10 for Resource id #35
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/builder/public_html/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 31
Load time so far: 0.12 seconds. Performing query: SELECT * FROM wsnlinks_members;
Load time so far: 0.15 seconds. Performing query: ALTER TABLE `phpbb_users` ADD `banned` TEXT NOT NULL;
Getting field list for table phpbb_users
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/builder/public_html/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 31
Load time so far: 0.15 seconds. Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.15 seconds. Performing query: SELECT FROM phpbb_users WHERE user_id=1 ;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 69
Mysql error while fetching row for :You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpbb_users WHERE user_id=1' at line 1
Load time so far: 0.16 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,priority FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpbb_users WHERE user_id=1' at line 1
Number of rows is 10 for Resource id #67
Load time so far: 0.16 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, phpbb_users WRITE;
Load time so far: 0.16 seconds. Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Load time so far: 0.16 seconds. Performing query: UNLOCK TABLES;
Warning: Cannot modify header information - headers already sent by (output started at /home/builder/public_html/classes/database.php:244) in /home/builder/public_html/commonfuncs.php on line 320
Load time so far: 0.19 seconds. Performing query: UPDATE wsnlinks_settings SET content='1112987280' WHERE name='lastrotation';
Load time so far: 0.19 seconds. Performing query: UPDATE wsnlinks_settings SET content='T' WHERE name='currentletter';
Load time so far: 0.19 seconds. Performing query: UPDATE wsnlinks_settings SET content='1112987280' WHERE name='staticexporttime';
Load time so far: 0.19 seconds. Performing query: SELECT user_id FROM phpbb_users WHERE user_id>0 ;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 82
Number of rows is for Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.19 seconds. Performing query: UPDATE wsnlinks_settings SET content='' WHERE name='totalmembers';
Load time so far: 0.22 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,priority FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY priority ASC LIMIT 0,300;
Number of rows is 4 for Resource id #71
Load time so far: 0.22 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 ;
Number of rows is 4 for Resource id #72
Warning: Cannot modify header information - headers already sent by (output started at /home/builder/public_html/classes/database.php:244) in /home/builder/public_html/commonfuncs.php on line 320
Warning: Cannot modify header information - headers already sent by (output started at /home/builder/public_html/classes/database.php:244) in /home/builder/public_html/end.php on line 29
Load time so far: 0.25 seconds. Performing query: SELECT id FROM wsnlinks_sessions WHERE memberid>0 ;
Number of rows is 1 for Resource id #74
Load time so far: 0.26 seconds. Performing query: SELECT id FROM wsnlinks_sessions WHERE memberid=0 ;
Number of rows is 0 for Resource id #75
Load time so far: 0.27 seconds. Performing query: SELECT COUNT(*) FROM wsnlinks_sessions WHERE 1=1 AND (memberid>0) ;
Load time so far: 0.27 seconds. Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname FROM wsnlinks_sessions WHERE 1=1 AND (memberid>0) ORDER BY time DESC LIMIT 0,100;
Number of rows is 1 for Resource id #79
Load time so far: 0.27 seconds. Performing query: SELECT FROM phpbb_users WHERE user_id=1 ;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 69
Mysql error while fetching row for :You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpbb_users WHERE user_id=1' at line 1
Have you confirmed via phpmyadmin that there actually is a phpbb_users table in the builder_directory database? It says there isn't. Naturally you can't login if the phpBB members table you're using members from doesn't exist and thus you have no members.
Sorry Paul, I'm new to PHP. I did a search for phpbb_users in phpmyadmin but couldn't find it. There's only 1 member (the admin). Everything worked fine until I changed some settings (can't remember all of them).
Well, do you have a phpBB forum installed? If you don't, why are you trying to integrate your member system with it? See scripts.webmastersite.net/w...inks/wsnmanual/articles/75 and follow the reversal instructions near the bottom there.
Comments on Can't Login Anymore + Error
Member
Usergroup: Customer
Joined: Apr 02, 2005
Total Topics: 8
Total Comments: 15
A problem: I changed some settings and now I can't login anymore. Also on top of my directory comes this error:
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/builder/public_html/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 31
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/builder/public_html/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 31
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 69
I turned on mod rewrite and the security graphic. I turned off the security graphic via PhpMyAdmin.
Any ideas?
Greetz,
Dirk.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Post the debug info (see the pinned thread).
Member
Usergroup: Customer
Joined: Apr 02, 2005
Total Topics: 8
Total Comments: 15
Hello Paul,
Here's the debug info:
Load time so far: 0.11 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;
Warning: Cannot modify header information - headers already sent by (output started at /home/builder/public_html/classes/database.php:244) in /home/builder/public_html/prestart.php on line 123
Load time so far: 0.12 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 23 for Resource id #31
Load time so far: 0.12 seconds.
Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 4 for Resource id #33
Load time so far: 0.12 seconds.
Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #34
Load time so far: 0.12 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
Number of rows is 10 for Resource id #35
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/builder/public_html/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 31
Load time so far: 0.12 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.12 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `links` INT NOT NULL default '0';
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `comments` INT NOT NULL default '0';
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `ip` TEXT NOT NULL;
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `totalhits` INT NOT NULL default '0';
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `totalhitsin` INT NOT NULL default '0';
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `validated` INT NOT NULL default '1';
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `template` TEXT NOT NULL;
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `language` TEXT NOT NULL;
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `lastattempt` TEXT NOT NULL;
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `allowemail` TEXT NOT NULL;
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `signature` TEXT NOT NULL;
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `avatarname` TEXT NOT NULL;
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `stylesheet` TEXT NOT NULL;
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.13 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `allowuseremail` TEXT NOT NULL;
Load time so far: 0.13 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.14 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `albumid` INT NOT NULL default '0';
Load time so far: 0.14 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.14 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `failedattempts` INT NOT NULL default '0';
Load time so far: 0.14 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.14 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `totalbytes` INT NOT NULL default '0';
Load time so far: 0.14 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.14 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `funds` INT NOT NULL default '0';
Load time so far: 0.14 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.14 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `notifyoflinks` TEXT NOT NULL;
Load time so far: 0.14 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.14 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `lastvisit` INT NOT NULL default '0';
Load time so far: 0.14 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.14 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `timezone` INT NOT NULL default '0';
Load time so far: 0.14 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.14 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `rating` INT NOT NULL default '0';
Load time so far: 0.14 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.14 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `pmfolders` TEXT NOT NULL;
Load time so far: 0.14 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.15 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `notifyofpms` TEXT NOT NULL;
Load time so far: 0.15 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.15 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `acceptpms` TEXT NOT NULL;
Load time so far: 0.15 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.15 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `cookieduration` INT NOT NULL default '0';
Load time so far: 0.15 seconds.
Performing query: SELECT * FROM wsnlinks_members;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.15 seconds.
Performing query: ALTER TABLE `phpbb_users` ADD `banned` TEXT NOT NULL;
Getting field list for table phpbb_users
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/builder/public_html/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 31
Load time so far: 0.15 seconds.
Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem FROM wsnlinks_membergroups WHERE id>0 ;
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.15 seconds.
Performing query: SELECT FROM phpbb_users WHERE user_id=1 ;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 69
Mysql error while fetching row for :You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpbb_users WHERE user_id=1' at line 1
Load time so far: 0.16 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,priority FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpbb_users WHERE user_id=1' at line 1
Number of rows is 10 for Resource id #67
Load time so far: 0.16 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, phpbb_users WRITE;
Load time so far: 0.16 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Table 'builder_directory.phpbb_users' doesn't exist
Number of rows is 0 for Resource id #68
Load time so far: 0.16 seconds.
Performing query: UNLOCK TABLES;
Warning: Cannot modify header information - headers already sent by (output started at /home/builder/public_html/classes/database.php:244) in /home/builder/public_html/commonfuncs.php on line 320
Load time so far: 0.19 seconds.
Performing query: UPDATE wsnlinks_settings SET content='1112987280' WHERE name='lastrotation';
Load time so far: 0.19 seconds.
Performing query: UPDATE wsnlinks_settings SET content='T' WHERE name='currentletter';
Load time so far: 0.19 seconds.
Performing query: UPDATE wsnlinks_settings SET content='1112987280' WHERE name='staticexporttime';
Load time so far: 0.19 seconds.
Performing query: SELECT user_id FROM phpbb_users WHERE user_id>0 ;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 82
Number of rows is for Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.19 seconds.
Performing query: UPDATE wsnlinks_settings SET content='' WHERE name='totalmembers';
Table 'builder_directory.phpbb_users' doesn't exist
Load time so far: 0.22 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,priority FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY priority ASC LIMIT 0,300;
Number of rows is 4 for Resource id #71
Load time so far: 0.22 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 ;
Number of rows is 4 for Resource id #72
Warning: Cannot modify header information - headers already sent by (output started at /home/builder/public_html/classes/database.php:244) in /home/builder/public_html/commonfuncs.php on line 320
Warning: Cannot modify header information - headers already sent by (output started at /home/builder/public_html/classes/database.php:244) in /home/builder/public_html/end.php on line 29
Load time so far: 0.25 seconds.
Performing query: SELECT id FROM wsnlinks_sessions WHERE memberid>0 ;
Number of rows is 1 for Resource id #74
Load time so far: 0.26 seconds.
Performing query: SELECT id FROM wsnlinks_sessions WHERE memberid=0 ;
Number of rows is 0 for Resource id #75
Load time so far: 0.27 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_sessions WHERE 1=1 AND (memberid>0) ;
Load time so far: 0.27 seconds.
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname FROM wsnlinks_sessions WHERE 1=1 AND (memberid>0) ORDER BY time DESC LIMIT 0,100;
Number of rows is 1 for Resource id #79
Load time so far: 0.27 seconds.
Performing query: SELECT FROM phpbb_users WHERE user_id=1 ;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/builder/public_html/classes/database.php on line 69
Mysql error while fetching row for :You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpbb_users WHERE user_id=1' at line 1
Thanks,
Dirk.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Table 'builder_directory.phpbb_users' doesn't exist
Have you confirmed via phpmyadmin that there actually is a phpbb_users table in the builder_directory database? It says there isn't. Naturally you can't login if the phpBB members table you're using members from doesn't exist and thus you have no members.
Member
Usergroup: Customer
Joined: Apr 02, 2005
Total Topics: 8
Total Comments: 15
Sorry Paul, I'm new to PHP. I did a search for phpbb_users in phpmyadmin but couldn't find it.
There's only 1 member (the admin). Everything worked fine until I changed some settings (can't remember all of them).
Kind Regards,
Dirk.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Well, do you have a phpBB forum installed? If you don't, why are you trying to integrate your member system with it? See scripts.webmastersite.net/w...inks/wsnmanual/articles/75 and follow the reversal instructions near the bottom there.
Member
Usergroup: Customer
Joined: Apr 02, 2005
Total Topics: 8
Total Comments: 15
Thanks so much Paul!