SMFHacks.com

SMF Classifieds => Support => Topic started by: ardvark on March 08, 2014, 06:56:37 am

Title: Error message
Post by: ardvark on March 08, 2014, 06:56:37 am
Hello,

SMF 2.0.7

Having some issues with Classifieds and trying to troubleshoot.  My error log shows this:

http://www.standupzone.com/forum/index.php?action=admin;area=classifieds;sa=layout

Apply Filter: Only show the errors with the same message

8: Undefined index: class_index_show_recent_comments

Apply Filter: Only show the errors from this file

File: /home/standup/public_html/forum/Themes/default/classifieds2.template.php (layout_settings sub template - eval?)
 Line: 812
Title: Re: Error message
Post by: SMFHacks on March 08, 2014, 12:02:14 pm
Go back to that page again in your admin area then check Show recent comments and save.
That error should then go away and then you can go back and uncheck it again
Title: Re: Error message
Post by: ardvark on March 09, 2014, 11:39:51 am
I am also getting a number of instances of the 3 errors below:


http://www.standupzone.com/forum/index.php?action=classifieds;sa=addlisting2

8192: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead.

File: /home/standup/public_html/forum/Sources/classifieds2.php
 Line: 9703

---------------------------------------------------------------------------------------------------------

http://www.standupzone.com/forum/index.php?action=classifieds&sa=addpic

8192: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead.

File: /home/standup/public_html/forum/Sources/classifieds2.php
 Line: 9703

---------------------------------------------------------------------------------------------------------

http://www.standupzone.com/forum/index.php?action=classifieds;sa=listingfiles;id=12

Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

File: /home/standup/public_html/forum/Sources/Load.php(2171) : eval()'d code
 Line: 2993
Title: Re: Error message
Post by: ardvark on March 09, 2014, 03:29:55 pm
PS:

For the first two errors I replaced all instances of mysql_escape_string with mysql_real_escape_string.  Was that correct?

I am unsure how to correct the third item:

Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

File: /home/standup/public_html/forum/Sources/Load.php(2171) : eval()'d code
 Line: 2993
Title: Re: Error message
Post by: SMFHacks on March 09, 2014, 11:09:09 pm
Posted an update that should fix the issues download at
http://www.smfhacks.com/index.php/topic,1149.msg6645.html#msg6645
Title: Re: Error message
Post by: ardvark on March 10, 2014, 08:39:59 am
Posted an update that should fix the issues download at
http://www.smfhacks.com/index.php/topic,1149.msg6645.html#msg6645

I am getting this error message at that link:

An Error Has Occurred!
The topic or board you are looking for appears to be either missing or off limits to you. 
Title: Re: Error message
Post by: SMFHacks on March 10, 2014, 08:43:32 am
Enter your classifieds license key under http://www.smfhacks.com/index.php?action=license to gain access to that board.
Title: Re: Error message
Post by: ardvark on March 10, 2014, 08:55:17 am
Hi,

When I entered that info it errored out.  When I tried again it noted that the key had already been used.  Unfortunately I am still getting the same error message on the download page.
Title: Re: Error message
Post by: SMFHacks on March 10, 2014, 08:56:19 am
PM me the license key used.
Title: Re: Error message
Post by: ardvark on March 10, 2014, 08:59:37 am
Yessir, the Key has been sent.
Title: Re: Error message
Post by: SMFHacks on March 10, 2014, 09:20:39 am
Hmm says you are in the group try again to access http://www.smfhacks.com/index.php/topic,1149.0.html
Title: Re: Error message
Post by: ardvark on March 10, 2014, 09:37:33 am
That worked.  I installed without removing the existing mod (I hope that was correct).  No errors yet :)
Title: Re: Error message
Post by: SMFHacks on March 10, 2014, 09:38:50 am
Yup that is the way to do it.
Title: Re: Error message
Post by: ardvark on March 10, 2014, 09:56:08 am
Awesome service.  I genuinely appreciate it!