Jump to content

Open Coterie  ·  19 members

SMF Staff People

non-critical database error on character approval


Jones
 Share

Recommended Posts

Testing those final bits. After hitting 'accept' from the character approval queue I got the error message:

Table 'operatio_bowtrucklesdb.smf_user_alerts' doesn't exist
File: /home/operatio/public_html/Sources/Subs-CharactersAdmin.php
Line: 2009

Everything seemed to go through fine- is this a leftover from the code being written on 2.1? That was my guess since it mentions user alerts. 

 

operation: bowtruckles & bombs

R6MmD.png

Link to comment
Share on other sites

Yes.

Send me your Subs-CharactersAdmin.php, and I'll dig it up and fix it and send it back.

Cause, tbh I don't remember where it is. Lol

nusignature.png nusignature.png

I am the darkness, always watching, always listening, ALWAYS THERE.
(If you're interested in Plain of Ice, message me, it's private. Bleach site, non-canon.)

Link to comment
Share on other sites

Should be okay now.

Fortunately, past-me commented it. Lol

(For everyone else, it's at the bottom of acmApproveCharacter and you probably want to get the one at the bottom of acmRejectCharacter too.)

Subs-CharactersAdmin.php

  • Thank you 1

nusignature.png nusignature.png

I am the darkness, always watching, always listening, ALWAYS THERE.
(If you're interested in Plain of Ice, message me, it's private. Bleach site, non-canon.)

Link to comment
Share on other sites

I was getting the same error but about shippers when trying to delete a character account. So I commented out the following block and its fine now.

	$smcFunc['db_query']('','
 		DELETE
 			FROM {db_prefix}acm_shippers
		WHERE id_character = {int:id_character}',
 		array(
 			'id_character' => $id_character
 		)
 	);

 

 

operation: bowtruckles & bombs

R6MmD.png

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use, Guidelines and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.