DragonPrime - LoGD Resource Community
Welcome Guest
  • Good afternoon, Guest.
    Please log in, or register.
  • February 20, 2019, 01:16:51 PM
Home Forums News Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Login
 
 
Resource Pages
Search

Pages: [1]   Go Down
  Print  
Author Topic: MySQL error (I think)  (Read 3681 times)
0 Members and 1 Guest are viewing this topic.
egdcltd
Militia
**
Offline Offline

Posts: 77


View Profile WWW
« on: March 24, 2006, 05:27:05 AM »

I have just upgraded from 1.0.2 to 1.0.6, and I'm getting the following problem:

When I exited the superuser grotto for the first time after upgrade, I got the following error

SELECT count(*) AS c FROM lotgd_mod_advertising_ba nners WHERE approved=0

Table 'directo_lotgd.lotgd_mod_ advertising_banners' doesn't exist
Call Stack:
1: db_query("SELECT count(*) AS c FROM...") called from /home/directo/public_html/games/lotgd/modules/advertising.php on line 258
2: advertising_dohook("superuser", Array()) called from /home/directo/public_html/games/lotgd/lib/modules.php on line 508
3: modulehook("superuser", Array(), true) called from /home/directo/public_html/games/lotgd/superuser.php on line 77

I now get the same error when I try and log back in to the superuser grotto.

I've checked in the MySQL database, and the table mentioned doesn't exist. I would assume it's something to do with the advertising module, but I don't think that's activated yet.
Logged

Nightborn
Guest
« Reply #1 on: March 24, 2006, 06:31:58 AM »

hmmmm

the module looks installed, else it wouldn't do anything.

yet the table should have been created upon install/reinstall/update.

I think it would be good to remove the hook in the table module_hooks for advertising to the superuser hook.

then you can enter normally and uninstall / reinstall the module
Logged
egdcltd
Militia
**
Offline Offline

Posts: 77


View Profile WWW
« Reply #2 on: March 24, 2006, 06:47:03 AM »

Should I just delete the row:
advertising     superuser     advertising_dohook     
Logged

Nightborn
Guest
« Reply #3 on: March 24, 2006, 06:49:12 AM »

that will suppress your error message and you should be able to enter the grotto
Logged
egdcltd
Militia
**
Offline Offline

Posts: 77


View Profile WWW
« Reply #4 on: March 24, 2006, 06:57:48 AM »

That got me back into the grotto, thanks. The advertising module is installed but not active; would that have something to do with it? ie, should it either be made active, or fully uninstalled?
Logged

Nightborn
Guest
« Reply #5 on: March 24, 2006, 07:09:52 AM »

1. if the module updates now, it will build the table you need and it should work

2. if it doesn't upgrade, everythings ok


yet I would advise you to generally uninstall all modules you don't need.
Logged
egdcltd
Militia
**
Offline Offline

Posts: 77


View Profile WWW
« Reply #6 on: March 24, 2006, 07:26:01 AM »

Found the table, it's been misnamed for some reason, as has advertising log. For some reason, lotgd_ has been missed off the beginning of each table name. I've renamed them manually, at least for the time being, but why weren't they created with the proper names?

Correction, I've now totally uninstalled the module after getting the following error:

PHP Warning: "fopen(crawl/superuser.php): failed to open stream: No such file or directory"
in /home/directo/public_html/games/lotgd/modules/advertising.php at 294.
Call Stack:
2: fopen("crawl/superuser.php", "w") called from /home/directo/public_html/games/lotgd/modules/advertising.php on line 294
3: advertising_dohook("everyfooter", Array(

    "__scriptfile__"=>"superuser"

)) called from /home/directo/public_html/games/lotgd/lib/modules.php on line 508
4: modulehook("everyfooter", Array(

    "__scriptfile__"=>"superuser"

)) called from /home/directo/public_html/games/lotgd/lib/pageparts.php on line 95
5: page_footer() called from /home/directo/public_html/games/lotgd/superuser.php on line 79
« Last Edit: March 24, 2006, 07:29:11 AM by egdcltd » Logged

kickme
Global Moderator
Mod God
*****
Offline Offline

Posts: 1589


Yay for elephants!


View Profile WWW
« Reply #7 on: March 24, 2006, 12:05:46 PM »

you need to make a file called crawl in the logd dir
Logged

Waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka waka
XChrisX
Global Moderator
Mod God
*****
Offline Offline

Posts: 4647

Be aware of the squirrel!


View Profile WWW
« Reply #8 on: March 24, 2006, 12:15:03 PM »

you need to make a file called crawl in the logd dir
No, you need a directory calles crawl... Wink

If don't want to use advertising, you should disable the module. Smiley
Logged

Running for more than three years now:
egdcltd
Militia
**
Offline Offline

Posts: 77


View Profile WWW
« Reply #9 on: April 03, 2006, 02:03:50 AM »

Thanks, I'll have a fiddle with it.
Logged

Pages: [1]   Go Up
  Print  
 
Jump to:  


*
DragonPrime Notices
Play LoGD on Dragonprime

Support Us
No funds raised yet this year
Your help is greatly appreciated!
Recent Topics
DragonPrime LoGD
Who's Online
28 Guests, 1 User
aeanos
Home Forums News Downloads Login Register Advanced Search