Sure it will be. The funny is that it will be in the Free version and not in the PRO as I've changed many things there. Promise that you'll have it next week.

Chris

First, I want to add my thanks to you for attempting to make this a viable product. And I realize how much effort it is taking you. So thanks a lot.

But I still do not understand the premium ads. What is the purpose of the check box at the bottom of the ad to make it a premium ad if it is only automatic?

But, in addition, I have made the person that posted the ads I wish to make premioum a certified member, and I made sure their usergroup is set at "1," but the ads will still not appear in the premium section.

So it appears that once an ad is posted, the premium status (or lack thereof) can not be changed by editing the ad, or by adding the creator to the certified list, or by changing the usergroup settings - is this correct? In other words, if a person forgets to check the box when creating the ad, there is nothing that can be done to make it a premium. Do I understand this correctly?

Will this work on older versions of VB? Like 4.1.3, 4.1.2?

Hi,
Today I installed product and I got an error:

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT AVG(microclassifieds_orders.sreviewrating) AS thisrating,
microclassifieds_profiles.* AS thisprofile
FROM microclassifieds_orders
JOIN microclassifieds_profiles
ON microclassifieds_profiles.userid=microclassifieds_ orders.sellerid
WHERE microclassifieds_orders.sreviewrating>0
GROUP BY microclassifieds_orders.sellerid
ORDER BY microclassifieds_orders.sreviewrating DESC
LIMIT 5;

MySQL 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 'AS thisprofile
FROM microclassifieds_orders

vb 4.1.5
Username : Admin
Classname : vB_Database
MySQL Version : 5.5.14-log

Could you tell me how to fix it?

Regards
Remek

i discovered a bug with the premium profiles at the bottom of the page. when clicking on a profile you get an invalid data error. looking at the link it appears that it using the wrong id in the link like its using ID instead of USERID in the microclassifieds_profiles table

i had to use phpmyadmin to change the premium settings for the profiles and items after they were posted.

Ah, good to know. I hope I am smart enough to figure out how you did that. I'm assuming you edited some DB tables???

I'm sure Chris will get a fix going for that in his spare time. :) Just kidding Chris. You are doing a fantastic job. I am making, and will be sending you a list of some English phrases, etc. that could be changed to make things more "polished," in appreciation and as a little help for your project.

Chris,

I understand you are not looking to add new features at this time, but allowing "free" classifieds should be a easy mod to make for the product. that would be amazingly helpful to many members, incl me. Thanks!

ndahiya

Hello, I discovered that classifieds are unfortunately not suitable for my forum. I went to uninstall the mod, and now, I'm getting fairly consistent emailed vBulletin errors.

"Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_microclassifieds AS phrasegroup_microclassifieds,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_posting AS phrasegroup_posting,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_microclassifieds' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 10th 2011 @ 07:35:12 PM
Error Date : Wednesday, August 10th 2011 @ 07:35:13 PM
Script : http://www.pbriot.com/classifieds.ph...le&profileid=1
Referrer :
IP Address : 66.249.67.66
Username :
Classname : vB_Database
MySQL Version :
"


Any ideas on how to fix it?

And here's another one as well

"Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_microclassifieds AS phrasegroup_microclassifieds,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_posting AS phrasegroup_posting,
language.phrasegroupinfo AS lang_phrasegroupinfo,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 30;

MySQL Error : Unknown column 'language.phrasegroup_microclassifieds' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 10th 2011 @ 07:51:03 PM
Error Date : Wednesday, August 10th 2011 @ 07:51:03 PM
Script : http://www.pbriot.com/classifieds.ph...le&profileid=1
Referrer : https://vborg.vbsupport.ru/showthrea...ght=classified
IP Address : 76.25.41.172
Username :
Classname : vB_Database
MySQL Version :
"