| PHP, MySQL General PHP questions. Or go to our PHPsuexec Forum >> |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread |
|
|
#1 (permalink) |
|
Registered User
Fresh Surpasser
Joined in Jun 2004
Lives in In a galaxy far far away
16 posts
Gave thanks: 0
Thanked 0 times
|
I just updated my site from 7.0 to 7.5
as it turns out that until 2 days ago I was running 7.4, I usually run the site for 2 to 3 days to make sure everything is ok and test everything with no problem for every update that has come out and I know all ready how to do the updates with no problem.However now that I installed 7.5 everything was ok till I apply the new 7.5 patch to avoid SQL injection, now I get this error when I try to work on the forums (You are not authorised to administer this board). I read every readme file that I found over and over looking to see what went wrong or if I forgot something to upload or to edit with no success.Also when I try to access a new feature that was added with 7.5 (_SECTIONSMANAGER) I get another error message. Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/ericore/public_html/sentinel/includes/sql_layer.php on line 286 Access Deniedr = dir("admin/case"); while($func=$casedir->read()) { if(substr($func, 0, 5) == "case.") { include($casedir->path."/$func"); } } closedir($casedir->handle); $result = $db->sql_query("SELECT title FROM ".$prefix."_modules ORDER BY title ASC"); while ($row = $db->sql_fetchrow($result)) { if (file_exists("modules/$row[title]/admin/index.php") AND file_exists("modules/$row[title]/admin/links.php") AND file_exists("modules/$row[title]/admin/case.php")) { include("modules/$row[title]/admin/case.php"); } } break; } } else { switch($op) { default: login(); break; } } ?> I'm not a sharp one when it comes to SQL . Have anyone have this error and how can I fix this. ThanksLast edited by Armageddon; October 6th, 2004 at 12:54 PM.. |
|
|
|
|
|
#4 (permalink) |
|
the one who was
Super #1
Joined in Jul 2003
Lives in Memphis
1,967 posts
Gave thanks: 0
Thanked 3 times
|
Honestly, I think you might be better off seeking this answer from PHPNuke's support in this case. Maybe someone here will know the answer but since this is their patch, it is quite likely they can answer you much faster. The SQL error generally means the mysql query wasn't valid and caused an error. It could be anything from a missing table in the database that needs to be added to support the new feature, to a simple typo in their code somewhere.
__________________
Patrick Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org |
|
|
|