Welcome, Guest
Username: Password: Remember me

TOPIC: SQL Error when posting an advertisement

SQL Error when posting an advertisement 1 year 10 months ago #4706

Hello,

I started working on our Classifieds again today.

I was able to add 1 advert from the front end without any problems. While adding a second advert from the front end, I am getting an SQL error which is pasted below.

Our domain is www.OneTopanage.com and I have previously provided Admin Access and FTP credentials to you so you should be able to get into our site if you need to.

How do we get this fixed?

Thanks,

Micah




Here is the SQL ERROR:

1064 - 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 1 SQL=SELECT price FROM jml3_jomcl_premium WHERE id=

YOU_MAY_NOT_BE_ABLE_TO_VISIT_THIS_PAGE_BECAUSE_OF:
1.AN_OUT_OF_DATE_BOOKMARK_FAVOURITE
2.A_SEARCH_ENGINE_THAT_HAS_AN_OUT_OF_DATE_LISTING_FOR_THIS_SITE
3.A_MIS_TYPED_ADDRESS
4.YOU_HAVE_NO_ACCESS_TO_THIS_PAGE
5.The requested resource was not found
6.An error has occurred while processing your request.

PLEASE_TRY_ONE_OF_THE_FOLLOWING_PAGES:
HOME_PAGE

IF_DIFFICULTIES_PERSIST__PLEASE_CONTACT_THE_SYSTEM_ADMINISTRATOR_OF_THIS_SITE

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 1 SQL=SELECT price FROM jml3_jomcl_premium WHERE id=
The administrator has disabled public write access.

SQL Error when posting an advertisement 1 year 10 months ago #4708

  • Super User
  • Super User's Avatar
  • Offline
  • Administrator
  • Posts: 2760
  • Thank you received: 292
  • Karma: 40
Dear Customer,

You please open your Joomla admin and click Jomclassifieds-->Premium. Here click the FREE membership and check the Repeat Always field. Here you should select "Yes" which will fix the issue.

Thanks.
The administrator has disabled public write access.

SQL Error when posting an advertisement 1 year 10 months ago #4746

Thanks, that fixed out problem.
The administrator has disabled public write access.
Time to create page: 0.234 seconds