Previous Thread
Next Thread
Print Thread
Rate Thread
#224736 09/17/2002 4:52 AM
Joined: Jun 2002
Posts: 375
Enthusiast
Enthusiast
Offline
Joined: Jun 2002
Posts: 375
I am in the final steps of testing a new hack for ubbt to let moderators add users to selected groups, but I am getting some errors while creating a new table with the SQL Command box in the admin menu. The table is created correctly, and is usable, but gives the following error:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\www.newoutriders.org\ubbthreads\mysql.inc.php on line 155

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\www.newoutriders.org\ubbthreads\mysql.inc.php on line 121

Anyone have any ideas? I am using this SQL command, which is copied from Max's Calendar 3.0 hack (which gives the same error btw)

code:

CREATE TABLE w3t_groupmods (
GM_Username varchar(30) NOT NULL,
GM_AddGroup tinyint(3) DEFAULT '3' NOT NULL,
GM_RemoveGroup varchar(1) NOT NULL,
KEY GM_Username (GM_Username)
);


Sponsored Links
Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
I got the same warnings when I tried that query with 6.1b2. The warnings do not occur if I do the query with phpMyAdmin or with the mysql command on the server.

I think the problem is that the script is attempting to display the query results, but the CREATE query does not produce any results. "CREATE" probably needs to be added to the list of commands for which results are not displayed.

In admin/dbdocommand.php:

if (!preg_match("/DELETE|INSERT|UPDATE|REPLACE|ALTER/i",$command)) {

Reported as bug.

Last edited by Dave_L; 09/17/2002 9:09 AM.
Joined: Jun 2002
Posts: 375
Enthusiast
Enthusiast
Offline
Joined: Jun 2002
Posts: 375
OK, well I guess my syntax is correct, so I'll keep this code and advise people to expect and then ignore the error in the hack directions.

Thanks Dave_L!


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)