ACM - Error when trying delete tab and icon question

[Cereza 2]

Trying to delete a tab in bio form area we get this error. Not even sure what to do with that lol :

An Error Has Occurred!

Wrong value type sent to the database. Integer expected. (varvars)

 

 

Also where do the icons go for the ACM? I don't see the modify and delete icons but the link is there. 

 

Thank you

 

Cereza

[Arceus 1,082]

This post answers the images question.

 

The first thing, I'm gonna need more than that, so check your error logs and whatever, see if you can get a filename or something, because this should only be happening when an ID is trying to turn itself into a negative number, and I don't... have any bloody idea what would be trying to do that re: deleting a tab. So. I need something more than just "this is a thing that happened" to fix that.

[Cereza 2]

Yes. sorry, didn't even think to look there. Here is the error log when I tried to do it. 

 

http://eternalsorrows.net/esforum/index.php?action=admin;area=mng_characters;sa=bio_form;sec=deletetab;id=2

Wrong value type sent to the database. Integer expected. (varvars)
Function: acmRemoveBioTab

File: /home/v2245ux2adfi/public_html/eternalsorrows.net/esforum/Sources/Subs-CharactersAdmin.php
Line: 1169

[Arceus 1,082]

Mmm apparently this is being caused by the code getting variables for fields that are attached to it, but it not being formatted the right way and being unable to make sense of it when it tries deleting bio data for that field. Because the field is deleted with its tab.

Best thing I can say is, try commenting this:

			if(!empty($field_vars))
			{
				foreach($field_vars as $varvars)
				{
					$smcFunc['db_query']('','
						DELETE
						FROM {db_prefix}acm_bio_data
						WHERE
							field_variable = {int:varvars}',
						array(
							'varvars' => $varvars
						)
					);
				}
			}

(Surround it in /* */)

in the Subs-CharactersAdmin file and see if it'll go like that. You'll still have bio data from a field that doesn't exist if it was there, but it should make it work.

... well, I guess you could also delete it lol

[Cereza 2]

Awesome! Thank you! it worked. I kept it in and surrounded it with /* */.

 

I may have more. We opted to doing a new forum as opposed to trying to fix the other one lol. 

[Cereza 2]

Ok so I have Another one. lol I should just change the thread to ACM  issues lol. 

Ok so I was doing up some journals for one of my characters and On the ACM journals page (Image included below) I clicked on Ja'lil's journals and go this error:

 

An Error Has Occurred!

The database value you're trying to insert does not exist: id_character

 

This is the error log.

http://eternalsorrows.net/esforum/index.php?action=characters;area=manage;sa=journal

The database value you're trying to insert does not exist: id_character
Function: acmLoadCharacterEdit

File: /home/v2245ux2adfi/public_html/eternalsorrows.net/esforum/Sources/Subs-Characters.php
Line: 871

 

Which corresponds with this code in the sub-characters file:
 

{
    global $smcFunc;
    
    $request = $smcFunc['db_query']('','
        SELECT
            *
        FROM {db_prefix}acm_characters
        WHERE id_character = {int:id_character}',
        array(
            'id_character' => $id_character
        )

 

So not sure what to do here. Tried to delete it and got a completely different error. lol

 

 

Edited July 4, 2019 by Cereza

[Arceus 1,082]

I actually don't think the journal system ever got finished in ACM, so it's probably a feature best left turned off...

Otherwise, it looks like it's not getting a character ID... actually it looks like there's a function running that function that should not be. So that's nice. I ... do not have either the time or patience to troubleshoot that, so, yeah, probably a feature best left turned off. I don't use ACM anymore, ftr, it's supported insofar as if I can fix it quickly without having to install it, okay, let's do it, but I'm not doing any new releases or bug fixes.

[Cereza 2]

Ok cool. Thank you