Mary's Classifieds

[maineGuy72]

the cron is scheduled to run every 10 mins so it is possible to get more than one PM per ad

[shanef]

Me too! I have disabled cron job to stop these messages.

lol well atleast its pm's not emails

[stationar]

PM said that the ad was deleted, but in fact, the ad is still active. What exactly the cron job does?

[stationar]

Another issue: I can't set ads to be premium. I check the box, but the item doesn't show as premium, and in database "premium" field is set to "0". Is this a bug, or it has to be enabled somewhere else?

[stationar]

I think, in microclassifieds_cron.php line 194 should be:

$timenow = time() - $grace_period; (currently $timenow = time() + $grace_period; )

Otherwise, it will try to delete ads that have not ended yet.

[Christos Teriakis]

**update**

if you download and install v 5.1.4. download this file and replace it with the classifieds.php in the zip file

What has this file in difference Mike?

[maineGuy72]

What has this file in difference Mike?

both lines 1401 and 1619 should have the microclassifieds/datagrid removed from between the ' '
should look like this
$objGrid -> language(' '.$vbulletin->options["microclassifieds_grid_langcode"].'');

[fwulfers]

Same thing for me with the PMs and had to disable the cron job as there were 100s of PMs. What's the best way to fix this?

[maineGuy72]

Same thing for me with the PMs and had to disable the cron job as there were 100s of PMs. What's the best way to fix this?

Try using that file chris uploaded for me to change the expiration date of all the ads.

https://vborg.vbsupport.ru/showpost.php?p=2245699&postcount=944

just remember to change the value to the number of days that you want before it expires

[fwulfers]

Thanks Mike and Chris, that seems to have worked with the expiration dates. I must have missed that post.

[Christos Teriakis]

both lines 1401 and 1619 should have the microclassifieds/datagrid removed from between the ' '
should look like this
$objGrid -> language(' '.$vbulletin->options["microclassifieds_grid_langcode"].'');

Its better to let it as it was and not change the phpmydatagrid.class.php That was which caused the problem. The path were in both files. phpmydatagrid.class.php is a third part file which can be update and loose anything, while in classifieds.php should be always there.

Chris

[Christos Teriakis]

As I mentioned I got those PM's also but those were all from ads who actually expired but never got deleted because of the con job not running properly. Now it is fixed of course all those expired are getting deleted and those PM's are normal.

If you feel you want to disable the cron job for now just go to:
Scheduled tasks -> scheduled task manager -> look for "microCLASSIFIEDS Cleanup" and disable it by selecting "disable" from the drop-down box

Note when you do this it will disable all tasks it is running and not just the ones with the PM's

Please try importing the attached file and check if reviews appear in user profile.

Chris

[qpurser]

Please try importing the attached file and check if reviews appear in user profile.

Chris

Sorry. They don't

Here are the files you requested in your PM. I had to add the .txt extensions otherwise the files arenot accepted for upload.

[Christos Teriakis]

Sorry. They don't

Here are the files you requested in your PM. I had to add the .txt extensions otherwise the files arenot accepted for upload.

What's the link of your site? Does a guest has access to classifieds?

Chris

[qpurser]

What's the link of your site? Does a guest has access to classifieds?

Chris

PM'd you with the credentials

[Christos Teriakis]

PM'd you with the credentials

Well, combining the details of the data that you sent me with the user details (userid) that I seen in your site, the "Buyer Whois", is correctly not showing the reviews, as even if the seller has reviewed the Buyer, the Buyer hasn't reviewed the seller yet. So the review is hidden till the expiration of time that you've setup for allowing reviews. eg 10 days after the sell date.

Chris

[qpurser]

Well, combining the details of the data that you sent me with the user details (userid) that I seen in your site, the "Buyer Whois", is correctly not showing the reviews, as even if the seller has reviewed the Buyer, the Buyer hasn't reviewed the seller yet. So the review is hidden till the expiration of time that you've setup for allowing reviews. eg 10 days after the sell date.

Chris

I did test sales and BOTH have been doing reviews. There might be some old ones where there was only one side reviews.

Here is a screenshot from the DB:

[maineGuy72]

i have the seller and buyer reviews and i have nothing
here is what the dbase looks like for the microclassifieds_order table

[qpurser]

i have the seller and buyer reviews and i have nothing
here is what the dbase looks like for the microclassifieds_order table

Yep.
Just edited my previous posting with a screenshot also.
Looks like yours

[Christos Teriakis]

Yep.
Just edited my previous posting with a screenshot also.
Looks like yours

Just in case that there is a typo that I can't see right now, I removed a conditional check, to hide the message "There are no......". If it's a typo it will shows the reviews, or nothing.
Please import the attached file.

Chris

[qpurser]

Just in case that there is a typo that I can't see right now, I removed a conditional check, to hide the message "There are no......". If it's a typo it will shows the reviews, or nothing.
Please import the attached file.

Chris

I imported the new one and I can see the text "No reviews etc..." is gone.
Did a test sale again. Both parties reviewed.
Ran the cron job.
From the moment a ran the cron job the "star rating" gets updated but still nothing in the "written reviews" just besides the no review text is gone.

Chris,
I think it is a cron job issue. Maybe there is nothing in there that actually updates those "whois review" stuff in the members profile?

[Christos Teriakis]

I imported the new one and I can see the text "No reviews etc..." is gone.
Did a test sale again. Both parties reviewed.
Ran the cron job.
From the moment a ran the cron job the "star rating" gets updated but still nothing in the "written reviews" just besides the no review text is gone.

Chris,
I think it is a cron job issue. Maybe there is nothing in there that actually updates those "whois review" stuff in the members profile?

No... something is wrong with code. As long as showrating =1 and buyerid or sellerid = userid they must appear there. I'll check it tomorrow morning. Now is too late for debugging. Needs clear mind.

Chris

[maineGuy72]

any word on the PM issue?

[qpurser]

No... something is wrong with code. As long as showrating =1 and buyerid or sellerid = userid they must appear there. I'll check it tomorrow morning. Now is too late for debugging. Needs clear mind.

Chris

Really appreciate this Chris.
This is the only one thing missing from your excellent mod

[murekhalir]

Looking for something similiar but has more features catered to a niche -- do you take freelance jobs?

Drop me a line.

[Christos Teriakis]

any word on the PM issue?

??? I've corrected something in PMs, in the cron file, which means automatic emails. What's the issue that you're talking about Mike?

Chris

[maineGuy72]

When you click on contact seller or place bid it sends 2 or more PMs the first goes to the seller and the other ones goto people watching the ad. the one to seller works fine the one to the people watching errors out. this is the one i talked with you about before. see error message below

[shanef]

any word on the PM issue?



I uploaded and ran the mike.php and changed all my ads to 30 days but i am still getting numerous pm's

[vb50kgpoo]

Upload this file to your forum directory. Login to your site (fronend) with your admin account. Change the URL to point to ...../mike.php

This file will update all Ads (except Auctions) to expire in 3650 days. If you want to change this value edit the mike.php file and edit the variable $days = at the top.

Chris

Chris, is this to change the max number of days from 15 to something else?
I can not find the number of days setting in admin

[Halfhidden]

Can I just say thanks for all your work and the latest bug fix. This is undoubtedly one of the most important mods Vbulletin has seen for some time.

[qpurser]

How to use premium classified feature?
I ticked premium option and clicked approve, but the Ad is not showing up in the box of premium classified.
Is this a bug?

Did you upgrade to the latest version Chris posted a couple days ago?
I did and it works fine for me. They all show up now in the Premium section

[RC-Central]

Are you able to sell downloadable items with this mod?? I have instructional videos that I sell and I would like to add them to my site for download. I just need to make sure it is only able to be downloaded 1 time per sale and not more.

[Christos Teriakis]

When you click on contact seller or place bid it sends 2 or more PMs the first goes to the seller and the other ones goto people watching the ad. the one to seller works fine the one to the people watching errors out. this is the one i talked with you about before. see error message below

Hello Mike,

As I don't have any installation with this version to check it, please do it for me. I did some changes in Bids, Contact Seller and Email to Friend.

Chris

[Christos Teriakis]

Are you able to sell downloadable items with this mod?? I have instructional videos that I sell and I would like to add them to my site for download. I just need to make sure it is only able to be downloaded 1 time per sale and not more.

No sorry. Why you don't try microCART? It fits the best for your needs.

Chris

[Christos Teriakis]

Can I just say thanks for all your work and the latest bug fix. This is undoubtedly one of the most important mods Vbulletin has seen for some time.

Any "Thanks" is always welcome :-)

Chris

[RC-Central]

No sorry. Why you don't try microCART? It fits the best for your needs.

Chris

I get all kinds of errors when using microcart and I am not a coder so I can not tell what I need to do in order to fix it.. :(

[Christos Teriakis]

Really appreciate this Chris.
This is the only one thing missing from your excellent mod

Try with this file. I found a typo.

Chris

[Christos Teriakis]

I get all kinds of errors when using microcart and I am not a coder so I can not tell what I need to do in order to fix it.. :(

PM me some of these errors, and tomorrow morning I'll give a look.

Chris

[qpurser]

Try with this file. I found a typo.

Chris

Not working yet.
I just imported the xml you just provided and checked the "override" option
Did a test sale again.
Both reviewed
ran cron jobs
Still get the "As for the moment, nobody reviewed him/her as Seller." in the users profile

[Christos Teriakis]

Not working yet.
I just imported the xml you just provided and checked the "override" option
Did a test sale again.
Both reviewed
ran cron jobs
Still get the "As for the moment, nobody reviewed him/her as Seller." in the users profile

I assume that:
1.- You're not getting any database errors
2.- That "Value as Buyer" and "Value as Seller" at the top are not zero.
Ok?
Also Seller reviews appear or not?

Chris

[maineGuy72]

Hello Mike,

As I don't have any installation with this version to check it, please do it for me. I did some changes in Bids, Contact Seller and Email to Friend.

Chris

yes it worked

[qpurser]

I assume that:
1.- You're not getting any database errors
2.- That "Value as Buyer" and "Value as Seller" at the top are not zero.
Ok?
Also Seller reviews appear or not?

Chris

1. No DB errors
2. They are not zero and every time I do a test sale or buy the star rating gets updated accordingly
3. seller AND buyer reviews still not showing

[Christos Teriakis]

yes it worked

Good to know. Now let's try to help qpuser as he is ready to start ....crying:D

Thank you Mike
Chris

[qpurser]

Good to know. Now let's try to help qpuser as he is ready to start ....crying:D

Thank you Mike
Chris

lol...Good to see you didn't gave up your humor :)
I am sure you will get it to work and mike Michael happy

[maineGuy72]

Good to know. Now let's try to help qpuser as he is ready to start ....crying:D

Thank you Mike
Chris

the only thing i can think of is its not pulling the id correctly like it was doing with the PM to people watching the ad.

[Christos Teriakis]

lol...Good to see you didn't gave up your humor :)
I am sure you will get it to work and mike Michael happy

Do you know about the nervous laughing?? .... This is how I'm right now. I don't believe what childish error is, but because is also normal mysql syntax, it does not produces any error.

When I'll be able to stop laughing, I'll correct it :D

Chris

[Christos Teriakis]

the only thing i can think of is its not pulling the id correctly like it was doing with the PM to people watching the ad.

No... It's very difficult to find it:
1.- Because the syntax is 100% correct
2.- It's childish error even for novice coders:eek:

Well, the error is that is not really runing the query. Just adds the query in a variable. It says:

$sellerwhois_sql = "SELECT * FROM ".TABLE_PREFIX."microclassifieds_orders WHERE sellerid=$userid AND showrating=1 ORDER BY sreviewdate DESC";

which is 100% correct if you want to store the query in a variable and run it at later time. But if you want to run the query right now the syntax is:

$sellerwhois_sql = $vbulletin->db->query_read("SELECT * FROM ".TABLE_PREFIX."microclassifieds_orders WHERE sellerid=$userid AND showrating=1 ORDER BY sreviewdate DESC");


So simple..............

[qpurser]

Do you know about the nervous laughing?? .... This is how I'm right now. I don't believe what childish error is, but because is also normal mysql syntax, it does not produces any error.

When I'll be able to stop laughing, I'll correct it :D

Chris

It is just weird the star rating is getting updated perfectly but not the reviews when they are stored in the DB (and yes they get stored. I saw them)
And it has nothing to do with the cron job?
Only thing I could find in there was about the rating but not about the reviews:
// Calculate the allowed time for rating
$maxdays = $vbulletin->options["microclassifieds_rating_limit"];
$timenow = time();
$timelimit = $timenow - ($maxdays * 86400);
// Update records for selldate >= timelimit
$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."microclassifieds_orders SET allowrating=0, showrating=1 WHERE selldate<=$timelimit");
// Also update records where Seller and Buyer have rate each other, even if timelimit hasn't expired
$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."microclassifieds_orders SET allowrating=0, showrating=1 WHERE breviewrating>0 AND sreviewrating>0");

[Christos Teriakis]

lol...Good to see you didn't gave up your humor :)
I am sure you will get it to work and mike Michael happy

Can you try this file? Don't need to add new sales etc. Try with old ones.

Chris

[Christos Teriakis]

It is just weird the star rating is getting updated perfectly but not the reviews when they are stored in the DB (and yes they get stored. I saw them)
And it has nothing to do with the cron job?
Only thing I could find in there was about the rating but not about the reviews:
// Calculate the allowed time for rating
$maxdays = $vbulletin->options["microclassifieds_rating_limit"];
$timenow = time();
$timelimit = $timenow - ($maxdays * 86400);
// Update records for selldate >= timelimit
$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."microclassifieds_orders SET allowrating=0, showrating=1 WHERE selldate<=$timelimit");
// Also update records where Seller and Buyer have rate each other, even if timelimit hasn't expired
$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."microclassifieds_orders SET allowrating=0, showrating=1 WHERE breviewrating>0 AND sreviewrating>0");

I've corrected it already. Is on the version that I'll release right now if you say me that the reviews are working.

Chris

[qpurser]

Can you try this file? Don't need to add new sales etc. Try with old ones.

Chris


:up::up::up::up::up::up::up::up:

Yeah...it worked.
The formatting is bad but that should be an easy fix.
Screenshot:

[Christos Teriakis]

:up::up::up::up::up::up::up::up:

Yeah...it worked.
The formatting is bad but that should be an easy fix.
Screenshot:

Try this file to see if the fieldser is appearing. The rest are missing phrase.

Chris

[Christos Teriakis]

Try this file to see if the fieldser is appearing. The rest are missing phrase.

Chris

This also fixes the missing phrase. Now everything must ok. Please confirm.

Chris

[qpurser]

Try this file to see if the fieldser is appearing. The rest are missing phrase.

Chris

Here is how it looks now using the xml from #1053
First attachment is with opera
Second one with Firefox
Third one with chrome.
As you can see the "image" is not showing properly. Maybe a wrong link in it?

[qpurser]

Formatting from #1054 is great now. Just missing the image on top of the review

[Christos Teriakis]

Formatting from #1054 is great now. Just missing the image on top of the review

Now?

[ProFifaLeagues]

Is there a way to edit the price must be greater then 0 as we have some members asking about this mod but they would also be giving items away
Thank you

EDIT:
Thanks the latest update sorted this!!!

[maineGuy72]

Is there a way to edit the price must be greater then 0 as we have some members asking about this mod but they would also be giving items away
Thank you

this have been addressed twice please search this mod

[Christos Teriakis]

this have been addressed twice please search this mod

In ver.5.1.5 I've removed the check for empty price, that's for this reason.

Chris

[maineGuy72]

i think with that ver all error will be corrected

[Christos Teriakis]

i think with that ver all error will be corrected

I hope so. Just to have some hours free to fix ....my site :D
By the way, as I seen that some users registered to ChrisTERiS.com. Should be a seperate site for Mary's Classifieds as I'm planing to release it for other platforms too. So you can stay tuned at: MarysClassifieds.com

Chris

[fwulfers]

At one point, the system would send out an email in addition to a PM when contacting a seller or buying an item. However, that doesn't seem to work anymore and there are only PMs.

Everything else is working great, even Contact Seller. yea! :)

[robbieswan]

Getting this error when I go to post a for sale ad

Fatal error: Declaration of vB_Attachment_Store_vBGlossary_GlossaryEntry::veri fy_permissions() must be compatible with that of vB_Attachment_Store::verify_permissions() in /home/shutter/public_html/packages/vbglossary/attach/glossaryentry.php on line 363

[qpurser]

Thanks for the update Chris.
It solved most issues and it is almost perfect.
Thanks so much again for all your hard work.

There are no major things I could find that might not work.

Just in the written reviews when there are a couple reviews it says:

See All Reviews as Seller (which is a link). When I click on it I get an empty page

Here is the URL that it gives. Replaced my URL with mysite.com

http://mysite.com/forums/member.php?u=544&action=3&tab=classifieds#classifieds

[stationar]

Still can't set items to be "premium". I check the checkbox, but changes don't save, and "premium" place is empty.
Also, is it possible to use phrases for words, used in grid "New/Used, Individual/Store"? Currently they are hard coded in classifieds.php

[maineGuy72]

Still can't set items to be "premium". I check the checkbox, but changes don't save, and "premium" place is empty.
Also, is it possible to use phrases for words, used in grid "New/Used, Individual/Store"? Currently they are hard coded in classifieds.php

i wrote up directions to follow to use the premium ads feature. please search this mod for the directions

[bam-met]

Tremendous work... Thank you VERY much... Does this version vs. a purchased version have many differences?

Thanks,

Mark

[Halfhidden]

Is there a paid version?.... I would buy it if it had some more features :)

[RC-Central]

Here is my error from microcart

Parse error: syntax error, unexpected $end in C:\wamp\www\admincp\microcart_admin.php on line 2781:confused:

and on my main forum I have these errors

( ! ) Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\cart.php on line 349

( ! ) Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\cart.php on line 2023

( ! ) Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\cart.php on line 2121

[claystation]

After upgrading this mod to 5.1.5, on the users profile page the left column is over lapping the the larger right column where the classifieds tab is located. When I disable this mod the problem goes away. Any ideas?
Thanks,
Andy

[stationar]

When I disable this mod the problem goes away. Any ideas?You don't need to disable the mod. Just disable the "Profile" module.
i wrote up directions to follow to use the premium ads feature.Found it, but it didn't help. I set usergroup priority to "1", and still can't set items to "premium".

[maineGuy72]

You don't need to disable the mod. Just disable the "Profile" module.
Found it, but it didn't help. I set usergroup priority to "1", and still can't set items to "premium".

any ad that is created before you change the priority will still not show as premium any new ads should. do you have access to the dbase via phpmyadmin?

[maineGuy72]

After upgrading this mod to 5.1.5, on the users profile page the left column is over lapping the the larger right column where the classifieds tab is located. When I disable this mod the problem goes away. Any ideas?
Thanks,
Andy

i confirm. i am looking into it tonight hopefully i will have an answer for you

[Pengzhu]

any ad that is created before you change the priority will still not show as premium any new ads should. do you have access to the dbase via phpmyadmin?

I followed your instruction and established a new usergroup.
also "premium user" post a new ad. but still nothing happen.

[maineGuy72]

I followed your instruction and established a new usergroup.
also "premium user" post a new ad. but still nothing happen.

can you send me a link to your site.

any access to dbase?

[stationar]

any ad that is created before you change the priority will still not show as premium any new ads should. do you have access to the dbase via phpmyadmin?I created new ads, and they don't save as premium either. Yes, I do have access to dbase, and all items (even new ones) have priority 99. In dbase I manually set priority to 1, and premium to 1, but after editing the item, it goes back to 99 and 0.

[maineGuy72]

I created new ads, and they don't save as premium either. Yes, I do have access to dbase, and all items (even new ones) have priority 99. In dbase I manually set priority to 1, and premium to 1, but after editing the item, it goes back to 99 and 0.

if you want PM me the login info and i will look into it

[maineGuy72]

After upgrading this mod to 5.1.5, on the users profile page the left column is over lapping the the larger right column where the classifieds tab is located. When I disable this mod the problem goes away. Any ideas?
Thanks,
Andy

try this file. see to work fine. the css file was throwing it off.

[qpurser]

try this file. see to work fine. the css file was throwing it off.

the XML file gives an error:

XML Error: Mismatched tag at Line 6985

[maineGuy72]

the XML file gives an error:

XML Error: Mismatched tag at Line 6985

try again i forgot to add something. updated the file in previous post

[maineGuy72]

did that work?

[qpurser]

try again i forgot to add something. updated the file in previous post

It fixes the profile issue but now I get this above the written reviews in bold:

Reviews as a Seller]></phrase> <phrase name="microclassifieds_buyer_whois" date="1259928193" username="MicroHellas" version="4.2.0"><![CDATA[Reviews as a Buyer

[maineGuy72]

oops hold on i was in the middle of fixing some wording in the phrases. give me 2 seconds

[maineGuy72]

file corrected here
https://vborg.vbsupport.ru/showpost.php?p=2246972&postcount=1078
let me know

[qpurser]

file corrected here
https://vborg.vbsupport.ru/showpost.php?p=2246972&postcount=1078
let me know

Perfect.
css issue solved

The only mistake I still see is when there are a couple written views a link appears at the bottom right saying: See all reviews as seller.
Clicking on that leads to an empty page.
I guess that is something for Chris to solve?

Thanks for fixing the css issue MaineGuy. You guys are the perfect team here

[maineGuy72]

it works out pretty well with the time difference between us. he handles the morning questions and i have the afternoon and evenings. i have no idea what i will do when this is 100%. haha
if you noticed the wording was changed from seller whois to reviews as a seller. i think it made more sense to have that words.

the link to blank page chris knows about but if you want to send me a link to where it is on your site i may be able to figure it out

[qpurser]

it works out pretty well with the time difference between us. he handles the morning questions and i have the afternoon and evenings. i have no idea what i will do when this is 100%. haha
if you noticed the wording was changed from seller whois to reviews as a seller. i think it made more sense to have that words.

the link to blank page chris knows about but if you want to send me a link to where it is on your site i may be able to figure it out

Yep..The wording makes more sense. Good catch

PM'd you the link and credentials

[maineGuy72]

hey chris on action 3 it references this

$perpage= $vbulletin->options['microclassifieds_perpage'];

but the perpage option relates to the number of ads on the page doesnt it?

<setting varname="microclassifieds_perpage" displayorder="100">
<datatype>free</datatype>
<defaultvalue>15</defaultvalue>
</setting>

or am i just reading it wrong?

[ProFifaLeagues]

Is there any way to remove Just the main Navbar Link??
I did this but it results in all Sub links to place an ad being removed too.
Plugin Manager and find the MicroClassifieds plugins. NAVTAB.set as not active.

[Christos Teriakis]

i wrote up directions to follow to use the premium ads feature. please search this mod for the directions

I've fixed it in ver 5.1.6, that I'll release it later today Mike.

Chris

[Christos Teriakis]

hey chris on action 3 it references this

$perpage= $vbulletin->options['microclassifieds_perpage'];

but the perpage option relates to the number of ads on the page doesnt it?

<setting varname="microclassifieds_perpage" displayorder="100">
<datatype>free</datatype>
<defaultvalue>15</defaultvalue>
</setting>

or am i just reading it wrong?

My mind now in like cracked eggs.... hmm... what do you mean exactly? The option microclassifieds_perpage is to calculate the rows per page in listings. Default is 15, but of course the user can change it. Is there a typo which I can't see now?

Chris

[Christos Teriakis]

Perfect.
css issue solved

The only mistake I still see is when there are a couple written views a link appears at the bottom right saying: See all reviews as seller.
Clicking on that leads to an empty page.
I guess that is something for Chris to solve?

Thanks for fixing the css issue MaineGuy. You guys are the perfect team here

According to the coding, this link must appears only if records (eg reviews) are more than 3. But if you're getting blank page, 2 things can be happen:
1.- The link is wrong
2.- The variable name is wrong.

I'll check it after my nap and I'll include it in my release today.

Chris

[Christos Teriakis]

Tremendous work... Thank you VERY much... Does this version vs. a purchased version have many differences?

Thanks,

Mark

Currently only a better inteface, by using datagrids globally. See at:

http://www.christeris.net/vb4/classifieds.php?do=main&catid=4
..and...
http://www.christeris.net/vb4/member.php?1-ChrisTERiS&tab=classifieds

to get an idea. Especially in User Profile-> Sold Products, click on the + to read the review.

Sorry if it still dosen't has superior additional features, but I don't like to use the Free version as marketing tool to buy the commercial.

Chris

[Christos Teriakis]

I followed your instruction and established a new usergroup.
also "premium user" post a new ad. but still nothing happen.

Wait the version 5.1.6 today. Was missing something for premium ads.

Chris

[Pengzhu]

there is a white square under "for sale wanted auction" section.
I don't know if other people have noticed or solved this issue.
see attachment.

[Christos Teriakis]

At one point, the system would send out an email in addition to a PM when contacting a seller or buying an item. However, that doesn't seem to work anymore and there are only PMs.

Everything else is working great, even Contact Seller. yea! :)

As I said, email are going out on every "Daily diggest" cron run. By default this runs once a day, so you need to change it.

Chris

[Christos Teriakis]

Hello,

I new update (ver 5.1.6) has been released. In this version:

I changed the way that lists and reviews appearing in user profile, grouping them in 3 sections: Active ads, Sold products (with reviews undermatch), Bought products (with reviews undermatch).
Fixed the Premium ads bug
Added missing phrases in classifieds.php (datagrid)
Fixed design issue in user profile... in general any post bug has been fixed.

To upgrade upload ALL files to your site and import product-microclassifieds.xml

Have a nice weekend
Chris

[maineGuy72]

Currently only a better inteface, by using datagrids globally. See at:

http://www.christeris.net/vb4/classifieds.php?do=main&catid=4
..and...
http://www.christeris.net/vb4/member.php?1-ChrisTERiS&tab=classifieds

to get an idea. Especially in User Profile-> Sold Products, click on the + to read the review.

Sorry if it still dosen't has superior additional features, but I don't like to use the Free version as marketing tool to buy the commercial.

Chris

i cant wait till the release of it

[vb50kgpoo]

How do I change max number of days for classified - can not find anything in admin

[maineGuy72]

Hello,

I new update (ver 5.1.6) has been released. In this version:
I changed the way that lists and reviews appearing in user profile, grouping them in 3 sections: Active ads, Sold products (with reviews undermatch), Bought products (with reviews undermatch).
Fixed the Premium ads bug
Added missing phrases in classifieds.php (datagrid)
Fixed design issue in user profile... in general any post bug has been fixed.

To upgrade upload ALL files to your site and import product-microclassifieds.xml

Have a nice weekend
Chris

i get a ton of errors when importing the product.xml file for the new version. anyone else get this?

[Christos Teriakis]

How do I change max number of days for classified - can not find anything in admin

It's on usergroup permissions.

Chris

[qpurser]

i get a ton of errors when importing the product.xml file for the new version. anyone else get this?

The whole screen is full with errors trying to import the XML

[Christos Teriakis]

i get a ton of errors when importing the product.xml file for the new version. anyone else get this?

Try this file. Maybe can't accept && as AND

Chris

[vb50kgpoo]

Just tried to install new release - big problem (this is just the start of what it says)

Unable to find a class to validate: vB_TemplateParser_Curlyrow on line 1084 in /home/antsword/public_html/includes/class_template_parser.php
#0 /home/antsword/public_html/includes/class_template_parser.php(1020): vB_TemplateParser->validate_curly(Object(vB_CurlyNode), Array)
#1 /home/antsword/public_html/includes/adminfunctions_template.php(3004): vB_TemplateParser->validate(Array)
#2 /home/antsword/public_html/includes/adminfunctions_plugin.php(1026): compile_template('??????
#3 /home/antsword/public_html/cadmin/plugin.php(1736): install_product(' #4 /home/antsword/public_html/vbseo.php(1397): require('/home/antsword/...')
#5 {main}

Fatal error: Unable to find a class to validate: vB_TemplateParser_Curlyrow on line 1084 in [path]/includes/class_template_parser.php in [path]/vb/vb.php on line 287
#0 vb_error_handler(256, Unable to find a class to validate: vB_TemplateParser_Curlyrow on line 1084 in /home/antsword/public_html/includes/class_template_parser.php , /home/antsword/public_html/vb/vb.php, 287, Array ([exception] => Exception Object ([] => Unable to find a class to validate: vB_TemplateParser_Curlyrow,[] => ,[] => 0,[] => /home/antsword/public_html/includes/class_template_parser.php,[] => 1084,[] => Array ([0] => Array ([file] => /home/antsword/public_html/includes/class_template_parser.php,[line] => 1020,[function] => validate_curly,[class] => vB_TemplateParser,[type] => ->,[args] => Array ([0] => vB_CurlyNode Object ([type] => curly,[value] => row,[attributes] => Array ([0] => sold_reviewdate),[] => 28),[1] => Array ())),[1] => Array ([file] => /home/antsword/public_html/includes/adminfunctions_template.php,[line] => 3004,[function] => validate,[class] => vB_TemplateParser,[type] => ->,[args] => Array ([0] => Array ())),[2] => Array ([file] => /home/antsword/public_html/includes/adminfunctions_plugin.php,[line] => 1026,[function] => c

[maineGuy72]

Try this file. Maybe can't accept && as AND

Chris
still errors

[vb50kgpoo]

This is with the amended file you provided

mporting Product, Please Wait...

[:]
Unable to find a class to validate: vB_TemplateParser_Curlyrow on line 1084 in /home/antsword/public_html/includes/class_template_parser.php
#0 /home/antsword/public_html/includes/class_template_parser.php(1020): vB_TemplateParser->validate_curly(Object(vB_CurlyNode), Array)
#1 /home/antsword/public_html/includes/adminfunctions_template.php(3004): vB_TemplateParser->validate(Array)
#2 /home/antsword/public_html/includes/adminfunctions_plugin.php(1026): compile_template('??????
#3 /home/antsword/public_html/cadmin/plugin.php(1736): install_product(' #4 /home/antsword/public_html/vbseo.php(1397): require('/home/antsword/...')
#5 {main}

Fatal error: Unable to find a class to validate: vB_TemplateParser_Curlyrow on line 1084 in [path]/includes/class_template_parser.php in [path]/vb/vb.php on line 287
#0 vb_error_handler(256, Unable to find a class to validate: vB_TemplateParser_Curlyrow on line 1084 in /home/antsword/public_html/includes/class_template_parser.php , /home/antsword/public_html/vb/vb.php, 287, Array ([exception] => Exception Object ([] => Unable to find a class to validate: vB_TemplateParser_Curlyrow,[] => ,[] => 0,[] => /home/antsword/public_html/includes/class_template_parser.php,[] => 1084,[] => Array ([0] => Array ([file] => /home/antsword/public_html/includes/class_template_parser.php,[line] => 1020,[function] => validate_curly,[class] => vB_TemplateParser,[type] => ->,[args] => Array ([0] => vB_CurlyNode Object ([type] => curly,[value] => row,[attributes] => Array ([0] => sold_reviewdate),[] => 28),[1] => Array ())),[1] => Array ([file] => /home/antsword/public_html/includes/adminfunctions_template.php,[line] => 3004,[function] => validate,[class] => vB_TemplateParser,[type] => ->,[args] => Array ([0] => Array ())),[2] => Array ([file] => /home/antsword/public_html/includes/adminfunctions_plugin.php,[line] => 1026,[function] => compile_template,[args] => Array ([0] => {vb:raw sold_product} {vb:raw sold_buyername} {vb:var vbphrase.microclassifieds_not_rated} {vb:var vbphrase.microclassifieds_hidden} {vb:raw sold_price} {vb:raw sold_selldate}

[vb50kgpoo]

Reverted to 5.1.5

[Christos Teriakis]

There is no reason to panic. It just don't imports the template. Nothing more serious. Even an unclosed "If" can bring such errors.

Chris

[vb50kgpoo]

It's on usergroup permissions.

Chris

Can't find it :erm:

[Christos Teriakis]

This one?

[Christos Teriakis]

Can't find it :erm:

Can you attach a screenshoot of microCLASSIFIEDS usergroup permissions?

Chris

[maineGuy72]

This one?

nope

[qpurser]

This one?

Failed also

[vb50kgpoo]

Can you attach a screenshoot of microCLASSIFIEDS usergroup permissions?

Chris

Hi Chris
This is the problem, I can't find microCLASSIFIEDS usergroup permissions

[WEBDosser]

same here.. got loads of errors after upgrade so uninstalled then tried to reinstall got same errors and it don't work at all..

[Christos Teriakis]

Failed also

This one 99% should worlks

Chris

[maineGuy72]

Hi Chris
This is the problem, I can't find microCLASSIFIEDS usergroup permissions

goto the usergroup --> usergroup manager --> edit usergroup
scroll down for heading saying microclassified permissions

[WEBDosser]

nope.. more than a page full of errors..

[maineGuy72]

This one 99% should worlks

Chris

i am in the 1%
doesnt work for me

[qpurser]

This one 99% should worlks

Chris

Sorry Chris

Still not working

[vb50kgpoo]

goto the usergroup --> usergroup manager --> edit usergroup
scroll down for heading saying microclassified permissions

Thanks Mike but there is nothing about number of days there

Can use microCLASSIFIEDS?
Yes No
Can Post Classifieds?
Yes No
Do you want to Approve Ads?
Yes No
Can use Autopost Feature?
Yes No
Can post Ad as Idividual?
Yes No
Can post Ad as Store Owner?
Yes No
Can Moderate Ads?
Yes No

Yes No
Max Concurrent Active Ads
Max Photos per Ad
Max Files per Ad
Listing Priority (1=Higher, 99=Lower)

[maineGuy72]

Thanks Mike but there is nothing about number of days there

Can use microCLASSIFIEDS?
Yes No
Can Post Classifieds?
Yes No
Do you want to Approve Ads?
Yes No
Can use Autopost Feature?
Yes No
Can post Ad as Idividual?
Yes No
Can post Ad as Store Owner?
Yes No
Can Moderate Ads?
Yes No

Yes No
Max Concurrent Active Ads
Max Photos per Ad
Max Files per Ad
Listing Priority (1=Higher, 99=Lower)

what version you running?
should be
Can use microCLASSIFIEDS? Yes No
Can Buy Products? Yes No
Can Post Classifieds? Yes No
Can set his own Ad expiration?
For Sale Ads and Wanted Ads, can the user set his own duration, or use the defaults (below)?
Yes No
Can change the expiration date?
This is common for all Ad types
Yes No
Do you want to Approve Ads? Yes No
Can use Autopost Feature? Yes No
Can post Ad as Idividual? Yes No
Can post Ad as Store Owner? Yes No
Can Moderate Ads? Yes No
Max Concurrent Active Ads
Max Photos per Ad
Max Files per Ad
Max duration (in days), while posting a For Sale Ad?
Max duration (in days), while posting a Wanted Ad?
Max duration (in days), while posting an Auction Ad?
Listing Priority (1=Higher, 99=Lower)30

[Christos Teriakis]

Sorry Chris

Still not working

Try and this one. If stile does not works:

1.- Logout and close your browser
2.- Login and try again

Chris

[mgcom]

just upgraded and got this (it was actually 2 pages long but this error is repeated throughout

Fatal error: Unable to find a class to validate: vB_TemplateParser_Curlyrow on line 1084 in [path]\includes\class_template_parser.php in [path]\vb\vb.php on line 287

[qpurser]

Try and this one. If stile does not works:

1.- Logout and close your browser
2.- Login and try again

Chris

Nope

Those are the first error lines:

Unable to find a class to validate: vB_TemplateParser_Curlyrow on line 1084 in /home/MYSITE/public_html/forums/includes/class_template_parser.php
#0 /home/MYSITE/public_html/forums/includes/class_template_parser.php(1020): vB_TemplateParser->validate_curly(Object(vB_CurlyNode), Array)
#1 /home/MYSITE/public_html/forums/includes/adminfunctions_template.php(3004): vB_TemplateParser->validate(Array)
#2 /home/MYSITE/public_html/forums/includes/adminfunctions_plugin.php(1026): compile_template('??????
#3 /home/MYSITE/public_html/forums/admincp/plugin.php(1736): install_product(' #4 {main}

replaced the URL with MYSITE

[Christos Teriakis]

Max Concurrent Active Ads
Max Photos per Ad
Max Files per Ad
Listing Priority (1=Higher, 99=Lower)

Most probably your usergoup permissions have been messed. Try a trick:

Remove the file bitfields_microclassifieds.xml from your site (vb_installation/includes/xml/)
Login to your admincp
Goto to usergroup pemissions
Click to edit Administrator group
You must see a message "Rebuilding bitfields".
Logout
Upload the file bitfields_microclassifieds.xml from your site (vb_installation/includes/xml/)
Login to your admincp
Click to edit Administrator group
You must see a message "Rebuilding bitfields".
.... Now the microCLASSIFIEDS permission must been updated.Chris

[WEBDosser]

still a lot of errors when importing product.. and it still don't work.

where is the old version xml

[Halfhidden]

@mgcom Chris is fixing that as we speak

[Christos Teriakis]

Nope

Those are the first error lines:

Unable to find a class to validate: vB_TemplateParser_Curlyrow on line 1084 in /home/tcmasorg/public_html/forums/includes/class_template_parser.php
#0 /home/tcmasorg/public_html/forums/includes/class_template_parser.php(1020): vB_TemplateParser->validate_curly(Object(vB_CurlyNode), Array)
#1 /home/tcmasorg/public_html/forums/includes/adminfunctions_template.php(3004): vB_TemplateParser->validate(Array)
#2 /home/tcmasorg/public_html/forums/includes/adminfunctions_plugin.php(1026): compile_template('??????
#3 /home/tcmasorg/public_html/forums/admincp/plugin.php(1736): install_product(' #4 {main}

Please import the attached file. Is from 5.1.5 version.

[qpurser]

Please import the attached file. Is from 5.1.5 version.

This one works but of course it is the older one and probably the reported bugs are not solved?

The CSS in the users profile is messed up again but the one MaineGuy posted should fix this issue

[vb50kgpoo]

Most probably your usergoup permissions have been messed. Try a trick:

Remove the file bitfields_microclassifieds.xml from your site (vb_installation/includes/xml/)
Login to your admincp
Goto to usergroup pemissions
Click to edit Administrator group
You must see a message "Rebuilding bitfields".
Logout
Upload the file bitfields_microclassifieds.xml from your site (vb_installation/includes/xml/)
Login to your admincp
Click to edit Administrator group
You must see a message "Rebuilding bitfields".
.... Now the microCLASSIFIEDS permission must been updated.Chris

Chris
Don't think that will work (this is your latest 5.1.5);

<?xml version="1.0" encoding="ISO-8859-1"?>

<bitfields product="microclassifieds">

<bitfielddefs>

<group name="ugp">

<group name="microclassifieds">

<bitfield name="access" group="microclassifieds_permissions" phrase="microclassifieds_access">1</bitfield>

<bitfield name="post" group="microclassifieds_permissions" phrase="microclassifieds_post">2</bitfield>

<bitfield name="approve" group="microclassifieds_permissions" phrase="microclassifieds_approve">4</bitfield>

<bitfield name="autopost" group="microclassifieds_permissions" phrase="microclassifieds_autopost">8</bitfield>

<bitfield name="postowner" group="microclassifieds_permissions" phrase="microclassifieds_postowner">16</bitfield>

<bitfield name="poststore" group="microclassifieds_permissions" phrase="microclassifieds_poststore">32</bitfield>

<bitfield name="moderate" group="microclassifieds_permissions" phrase="microclassifieds_moderate">64</bitfield>

<bitfield name="modcertified" group="microclassifieds_permissions" phrase="microclassifieds_modcertified">128</bitfield>

<bitfield intperm="true" name="mc_maxads" group="microclassifieds_permissions" phrase="microclassifieds_maxads">0</bitfield>

<bitfield intperm="true" name="mc_maxphotos" group="microclassifieds_permissions" phrase="microclassifieds_maxphotos">5</bitfield>

<bitfield intperm="true" name="mc_maxfiles" group="microclassifieds_permissions" phrase="microclassifieds_maxfiles">5</bitfield>

<bitfield intperm="true" name="mc_priority" group="microclassifieds_permissions" phrase="microclassifieds_priority">99</bitfield>

</group>

</group>

</bitfielddefs>

</bitfields>

[Christos Teriakis]

This one works but of course it is the older one and probably the reported bugs are not solved?

The CSS in the users profile is messed up again but the one MaineGuy posted should fix this issue

I have fixed it in 5.1.6 ... in any case.... as vB templating is crazy, can you try again the 5.1.6 file? Sometimes (happen to me), even if the error has been corrected, it stay there in the old error.

[maineGuy72]

hey chris i narrowed it down to 2 templates
the microclassifieds_profile_sold_ads and microclassifieds_profile_bought_ads if i see something i will let you know

[Christos Teriakis]

Chris
Don't think that will work (this is your latest 5.1.5);


Wrong... This is the content. I just copied from the zip file:

<?xml version="1.0" encoding="ISO-8859-1"?>
<bitfields product="microclassifieds">
<bitfielddefs>
<group name="ugp">
<group name="microclassifieds">
<bitfield name="access" group="microclassifieds_permissions" phrase="microclassifieds_access">1</bitfield>
<bitfield name="buy" group="microclassifieds_permissions" phrase="microclassifieds_buy">2</bitfield>
<bitfield name="post" group="microclassifieds_permissions" phrase="microclassifieds_post">4</bitfield>
<bitfield name="postduration" group="microclassifieds_permissions" phrase="microclassifieds_postduration">8</bitfield>
<bitfield name="editduration" group="microclassifieds_permissions" phrase="microclassifieds_editduration">16</bitfield>
<bitfield name="approve" group="microclassifieds_permissions" phrase="microclassifieds_approve">32</bitfield>
<bitfield name="autopost" group="microclassifieds_permissions" phrase="microclassifieds_autopost">64</bitfield>
<bitfield name="postowner" group="microclassifieds_permissions" phrase="microclassifieds_postowner">128</bitfield>
<bitfield name="poststore" group="microclassifieds_permissions" phrase="microclassifieds_poststore">256</bitfield>
<bitfield name="moderate" group="microclassifieds_permissions" phrase="microclassifieds_moderate">512</bitfield>
<bitfield intperm="true" name="mc_maxads" group="microclassifieds_permissions" phrase="microclassifieds_maxads">1</bitfield>
<bitfield intperm="true" name="mc_maxphotos" group="microclassifieds_permissions" phrase="microclassifieds_maxphotos">5</bitfield>
<bitfield intperm="true" name="mc_maxfiles" group="microclassifieds_permissions" phrase="microclassifieds_maxfiles">5</bitfield>
<bitfield intperm="true" name="mc_max1dur" group="microclassifieds_permissions" phrase="microclassifieds_max1dur">30</bitfield>
<bitfield intperm="true" name="mc_max2dur" group="microclassifieds_permissions" phrase="microclassifieds_max2dur">60</bitfield>
<bitfield intperm="true" name="mc_max3dur" group="microclassifieds_permissions" phrase="microclassifieds_max3dur">15</bitfield>
<bitfield intperm="true" name="mc_priority" group="microclassifieds_permissions" phrase="microclassifieds_priority">99</bitfield>
</group>
</group>
</bitfielddefs>
</bitfields>


max1dur, max2dur.... are missing from you. Maybe your unzip utility in not working well. I'm attaching the file. Please note that these changes, made lot of versions ago.

Chris

[Christos Teriakis]

I got a bit stressed... sorry I'll go to get a shower and be back soon.

Chris

[qpurser]

I have fixed it in 5.1.6 ... in any case.... as vB templating is crazy, can you try again the 5.1.6 file? Sometimes (happen to me), even if the error has been corrected, it stay there in the old error.

I tried again the 5.1.6 from #1123
Still the same error

No worries..Take you time.
A shower might help to clear your mind...:)

[mgcom]

I got a bit stressed... sorry I'll go to get a shower and be back soon.

Chris

thanks for your time mate, no pressure :D

[Christos Teriakis]

I don't believe it ... dozens of error pages for a vb:row insteal vb:raw :o

The correct file is here, and soon I'll re-upload the zip file.

Chris

[WEBDosser]

that works.. thanks :)

[qpurser]

that works.. thanks :)

The import works
BUT

when I click on the avatar where it says TOP sellers etc...
and also when I try to go to "my profile"

I get this error:

Database error in vBulletin 4.1.5:

Invalid SQL:
SELECT * FROM microclassifieds_orders WHERE sellerid= ORDER BY selldate DESC;

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 'ORDER BY selldate DESC' at line 1
Error Number : 1064
Request Date : Saturday, September 17th 2011 @ 12:54:00 PM
Error Date : Saturday, September 17th 2011 @ 12:54:01 PM
Script : http://komet.urljet.com/~tcmasorg/forums/member.php?544-MAXreefer&tab=classifieds
Referrer : http://komet.urljet.com/~tcmasorg/forums/classifieds.php
IP Address : 98.240.153.128
Username : MAXreefer
Classname : vB_Database
MySQL Version : 5.0.92-community-log

[maineGuy72]

I don't believe it ... dozens of error pages for a vb:row insteal vb:raw :o

The correct file is here, and soon I'll re-upload the zip file.

Chris

imports but get
Invalid SQL:
SELECT * FROM microclassifieds_orders WHERE sellerid= ORDER BY selldate DESC;

on profile screen

[mgcom]

I don't believe it ... dozens of error pages for a vb:row insteal vb:raw :o

The correct file is here, and soon I'll re-upload the zip file.

Chris

Love this mod, all sites in Ireland charge to advertise classifieds, hoping this will get me plenty of members

will make a donation soon

thanks for all the work

:up:

[vb50kgpoo]

Wrong... This is the content. I just copied from the zip file:

<?xml version="1.0" encoding="ISO-8859-1"?>
<bitfields product="microclassifieds">
<bitfielddefs>
<group name="ugp">
<group name="microclassifieds">
<bitfield name="access" group="microclassifieds_permissions" phrase="microclassifieds_access">1</bitfield>
<bitfield name="buy" group="microclassifieds_permissions" phrase="microclassifieds_buy">2</bitfield>
<bitfield name="post" group="microclassifieds_permissions" phrase="microclassifieds_post">4</bitfield>
<bitfield name="postduration" group="microclassifieds_permissions" phrase="microclassifieds_postduration">8</bitfield>
<bitfield name="editduration" group="microclassifieds_permissions" phrase="microclassifieds_editduration">16</bitfield>
<bitfield name="approve" group="microclassifieds_permissions" phrase="microclassifieds_approve">32</bitfield>
<bitfield name="autopost" group="microclassifieds_permissions" phrase="microclassifieds_autopost">64</bitfield>
<bitfield name="postowner" group="microclassifieds_permissions" phrase="microclassifieds_postowner">128</bitfield>
<bitfield name="poststore" group="microclassifieds_permissions" phrase="microclassifieds_poststore">256</bitfield>
<bitfield name="moderate" group="microclassifieds_permissions" phrase="microclassifieds_moderate">512</bitfield>
<bitfield intperm="true" name="mc_maxads" group="microclassifieds_permissions" phrase="microclassifieds_maxads">1</bitfield>
<bitfield intperm="true" name="mc_maxphotos" group="microclassifieds_permissions" phrase="microclassifieds_maxphotos">5</bitfield>
<bitfield intperm="true" name="mc_maxfiles" group="microclassifieds_permissions" phrase="microclassifieds_maxfiles">5</bitfield>
<bitfield intperm="true" name="mc_max1dur" group="microclassifieds_permissions" phrase="microclassifieds_max1dur">30</bitfield>
<bitfield intperm="true" name="mc_max2dur" group="microclassifieds_permissions" phrase="microclassifieds_max2dur">60</bitfield>
<bitfield intperm="true" name="mc_max3dur" group="microclassifieds_permissions" phrase="microclassifieds_max3dur">15</bitfield>
<bitfield intperm="true" name="mc_priority" group="microclassifieds_permissions" phrase="microclassifieds_priority">99</bitfield>
</group>
</group>
</bitfielddefs>
</bitfields>


max1dur, max2dur.... are missing from you. Maybe your unzip utility in not working well. I'm attaching the file. Please note that these changes, made lot of versions ago.

Chris

OK, I have done this and yes, I can now change the number of days. However, there is a bug.

I have three categories; "For Sale", "Wanted" or "Auction" for which I have selected 365, 365 and 30 days respectively.

However, no matter which of the three I select from the drop down menu from the navbar, I get "For Sale" in the form that appears (it does however show the correct number of days). So, if I select "Wanted" and then try to change it to "Auction" in the drop down menu on the posting form, it remains at 365 days, it does not go to 30 days.

I select "Auctions" and get this;
https://vborg.vbsupport.ru/attachment.php?attachmentid=133077&stc=1&d=1316282774

[maineGuy72]

line 5534 spelling error on userid

[maineGuy72]

also review text is not displaying in user profile.

**
line 5550 and 5571
spelling error
reviewtext (not reviewtetext)

[qpurser]

also review text is not displaying in user profile.

How can you get to the user profile?
I can not as I have the same SQL error as you mentioned which is also happening when going to a profile.

[maineGuy72]

How can you get to the user profile?
I can not as I have the same SQL error as you mentioned which is also happening when going to a profile.

i posted the line corrections for chris.

[Christos Teriakis]

How can you get to the user profile?
I can not as I have the same SQL error as you mentioned which is also happening when going to a profile.

Sure... reviewtetext in not correct... reviewtext is:(

Correct file attached, plus another typo in userid.

EDITED: Zip file updated

Chris

[maineGuy72]

almost ready for a nap there chris? haha

[qpurser]

Sure... reviewtetext in not correct... reviewtext is:(

Correct file attached, plus another typo in userid.

EDITED: Zip file updated

Chris

Perfect Chris. :up:
No more errors so far

[qpurser]

Sure... reviewtetext in not correct... reviewtext is:(

Correct file attached, plus another typo in userid.

EDITED: Zip file updated

Chris

Perfect Chris. :up:
No more errors so far

[Christos Teriakis]

OK, I have done this and yes, I can now change the number of days. However, there is a bug.

I have three categories; "For Sale", "Wanted" or "Auction" for which I have selected 365, 365 and 30 days respectively.

However, no matter which of the three I select from the drop down menu from the navbar, I get "For Sale" in the form that appears (it does however show the correct number of days). So, if I select "Wanted" and then try to change it to "Auction" in the drop down menu on the posting form, it remains at 365 days, it does not go to 30 days.

I select "Auctions" and get this;
https://vborg.vbsupport.ru/attachment.php?attachmentid=133077&stc=1&d=1316282774

"For Sale", "Wanted", "Auctions" are build-in categories. You can't use categories with these names and expect to find the settings of the build-in categories in your categories.

Chris

[Christos Teriakis]

Love this mod, all sites in Ireland charge to advertise classifieds, hoping this will get me plenty of members

will make a donation soon

thanks for all the work

:up:

In a few days, when the PRO version will be available, contact me to give you a copy. I also belong to one of the 3 most ...rich countries:D

Chris

[Christos Teriakis]

almost ready for a nap there chris? haha

almost ready.... still spying here in case that something will goes wrong. Not my lucky day today.

[maineGuy72]

ya i check back once and a while otherwise its the couch and tv for me

[1320Nation]

It is what it is. Or is there info somewhere on each version upgrade(current upgrade info stops at version 4.9.5a)? Also can certain files be upgraded between versions instead of reloading the entire mod? If not, is there a benefit to reloading the entire mod?

[Christos Teriakis]

It is what it is. Or is there info somewhere on each version upgrade(current upgrade info stops at version 4.9.5a)? Also can certain files be upgraded between versions instead of reloading the entire mod? If not, is there a benefit to reloading the entire mod?

There are lot of changes in many files. So instead to give a list of 10 files to upload, I prefer to say "Upload all files". What's the problem on it? You need more time to find 10 files in 10 different directories, than to upload the entire package. eg on the previous versions there were changes on each css file of datagrid. What I had to say? Upload:

microclassifieds/datagrid/styles/bluesky/css/dgstyle.css
.....
microclassifieds/datagrid/styles/redsky/css/dgstyle.css

??

Chris

[vb50kgpoo]

"For Sale", "Wanted", "Auctions" are build-in categories. You can't use categories with these names and expect to find the settings of the build-in categories in your categories.

Chris

Hi Chris / Anyone
Sorry, this does not mean anything to me. How do I resolve the problem?
Regards / RSVP
AS

[Christos Teriakis]

Hi Chris / Anyone
Sorry, this does not mean anything to me. How do I resolve the problem?
Regards / RSVP
AS

You can't resolve this problem as there is not problem. You're trying to do something that the program is not supporting. Similar to ask the program to prepare a cup of coffee.

If you still count it as a problem, just uninstall it.

Chris

[mgcom]

not sure if it has been mentioned or getting worked on but on the 2nd page of submitting a thumbnail the thumbnail cropper does not work, in fact no images are displaying with the ads, i've even uploaded 60X60 images and still nothing.

Do i need to chmod some folder or something ?

[Christos Teriakis]

not sure if it has been mentioned or getting worked on but on the 2nd page of submitting a thumbnail the thumbnail cropper does not work, in fact no images are displaying with the ads, i've even uploaded 60X60 images and still nothing.

Do i need to chmod some folder or something ?

Yes. The following directories must be cmod 777:
microclassifieds/photos/
microclassifieds/photos/thumbs/
microclassifieds/photos/tmp/
microclassifieds/files/ (for attachments)

Chris

[hsoen]

Yes. The following directories must be cmod 777:
microclassifieds/photos/
microclassifieds/photos/thumbs/
microclassifieds/photos/tmp/
microclassifieds/files/ (for attachments)

Chris

Hi Chris,

Sorry to ask you a basic question.

May I know where do the classified product images uploaded by users stored? Is it in vbulletin mysql database (for image attachments)? or Is it in microclassifieds/files/ (for attachments), i.e. forum file directory?

[Christos Teriakis]

Hi Chris,

Sorry to ask you a basic question.

May I know where do the classified product images uploaded by users stored? Is it in vbulletin mysql database (for image attachments)? or Is it in microclassifieds/files/ (for attachments), i.e. forum file directory?

All uploads (photos and attachments) are storing in the web space, ignoring your vB settings.

Chris

[RC-Central]

PM sent.

[qpurser]

Morning Chris,
The newest version rocks and almost everything is solved now.

I just found something with the "datagrid"
** I looked up the datagrid manual and it says in the manual to have the datagrid using the whole width of the screen you have to set this: $objGrid -> liquidTable = false;
I changed it in your phpmydatagrid.class.php from false to true but that didn't change anything.

**For some reason the "condition" text (new/used) doesn't show up in the datagrid.
This is the code you have from the latest classifieds.php:

$objGrid-> FormatColumn("newused","".$vbphrase["microclassifieds_condition"]."", "5", "30", 1, "80", "center", "select:1_".$vbulletin->options["microclassifieds_new_item"].":2_".$vbulletin->options["microclassifieds_used_item"]."");
$arrConditions = array("['adtype']==3" => "['buynow']",
"['adtype']!=3" => "['price']"

** If you look in the screenshot below the datagrid. It shows my "body" background I am using in the site instead of just the plain white background.

[vb50kgpoo]

You can't resolve this problem as there is not problem. You're trying to do something that the program is not supporting. Similar to ask the program to prepare a cup of coffee.

If you still count it as a problem, just uninstall it.

Chris

??????????????????????? ouch !!!!!!!!!!!!!!!!!!!!!!!!!!

Chris
It is a problem, but say it is not and to tell me to uninstall it........!
If it is not an issue with the add-on, then tell me what I am doing wrong?!
If I can not set 3 different max. days for the 3 options, why allow me to do this in admin (user permissions)?
If I have made a problem, tell me what I have done!
Can anyone else help, please?

Again
I have 3 options; "For Sale", "Wanted", "Auction"

Problem 1;
When I click to make / post a classified, I always get the "For Sale" option showing in the classified form, even when I click "Auction" (from the drop down menu that appears when I click to post a classified). Though the correct max. number of days shows.

Problem 2;
I have different max. days set for each of the 3 options. If I change the pull down menu on the classified posting form from, say, "Auction" to "Wanted", the max. days for Auctions remains, even though the max. days for "Wanted" is different. A user then thinks they can enter the wrong max. number of days.

Anyone? https://vborg.vbsupport.ru/images/smilies/frown.gif

[Christos Teriakis]

Morning Chris,
The newest version rocks and almost everything is solved now.

I just found something with the "datagrid"
** I looked up the datagrid manual and it says in the manual to have the datagrid using the whole width of the screen you have to set this: $objGrid -> liquidTable = false;
I changed it in your phpmydatagrid.class.php from false to true but that didn't change anything.

Wrong. linguidTable must be true and below you need to setup the width. eg width = '100%'. But the problem is not there. You need to set the width of every column ($objGrid-> FormatColumn). It's the value before the aligment. The problem is that this version supports only fixed width. To be honest, I've a version which support related width (eg 20 means 20% and not 20px as this one), but as I've paid the author to make this custom work for me (also make column title clickables for changing ordering and removed the arrows on the left), I will include this updated version only with my PRO version.


**For some reason the "condition" text (new/used) doesn't show up in the datagrid.
This is the code you have from the latest classifieds.php:

$objGrid-> FormatColumn("newused","".$vbphrase["microclassifieds_condition"]."", "5", "30", 1, "80", "center", "select:1_".$vbulletin->options["microclassifieds_new_item"].":2_".$vbulletin->options["microclassifieds_used_item"]."");
$arrConditions = array("['adtype']==3" => "['buynow']",
"['adtype']!=3" => "['price']"


** If you look in the screenshot below the datagrid. It shows my "body" background I am using in the site instead of just the plain white background.

Typo as usally. Its vbphrase an not vboptions at:
"select:1_".$vbphrase["microclassifieds_new_item"].":2_".$vbphrase["microclassifieds_used_item"]."");

Chris

[qpurser]

Wrong. linguidTable must be true and below you need to setup the width. eg width = '100%'. But the problem is not there. You need to set the width of every column ($objGrid-> FormatColumn). It's the value before the aligment. The problem is that this version supports only fixed width. To be honest, I've a version which support related width (eg 20 means 20% and not 20px as this one), but as I've paid the author to make this custom work for me (also make column title clickables for changing ordering and removed the arrows on the left), I will include this updated version only with my PRO version.



Typo as usally. Its vbphrase an not vboptions at:
"select:1_".$vbphrase["microclassifieds_new_item"].":2_".$vbphrase["microclassifieds_used_item"]."");

Chris

Thanks Chris.
Grid works now
Could you figure out why I have the blue background below the grid?

Is the PRO version already available? If so is there a link to it?

[Christos Teriakis]

Could you figure out why I have the blue background below the grid?

Any link???

[Thomasmp]

Hello, thank you very much for this modification.

I am testing a test forum.

there is a chance that we can get the language file to translate it into Spanish?

[Christos Teriakis]

??????????????????????? ouch !!!!!!!!!!!!!!!!!!!!!!!!!!

Chris
It is a problem, but say it is not and to tell me to uninstall it........!
If it is not an issue with the add-on, then tell me what I am doing wrong?!


First of all I'm not unfriendly. Actually I'm very polite. But when you're ignoring my replies, just because they're not what you expecting, is not my fault.

Once more I'll tell you what you're doing wrong. You've setupe as categories:

For Sale
Wanted
AuctionsThat's WRONG. These can't be categories. These are DEFINITIONS of a Classified. eg categories can be: Automotives with subcategories Cars, Motos, Bikes etc. Then every post classified in these categories (or subcategories), have a DEFINITION of what type they are: eg Car for Sale, or Wanted Car etc.

So, all build in settings in the program are for the build in definitions. eg 30 days max duration for Sale Ads, or 10 days for Auctions etc. It's impossible to assign settings for categories, simple because I don't know what every user will setup as categories.

After all, you need to change the categories structure. If you change them, then everything will works as it has planed to work.

Thank you
Chris

[qpurser]

Any link???

I posted a screenshot in post #1165

If you need more info I can PM you the credentials to the site

[Christos Teriakis]

Hello, thank you very much for this modification.

I am testing a test forum.

there is a chance that we can get the language file to translate it into Spanish?

here is the file with the phrases. It's from the PRO version, but it's not a problem other than you'll need to translate some more phrases. Sorry but I don't have the Free version installed.

Chris

[Christos Teriakis]

I posted a screenshot in post #1165

If you need more info I can PM you the credentials to the site

In the Free version I'm using datagrid in iframes. Later on I found a way to include them in vB templates, but this will be only in the pro version. If I remember well I've setup the iframe's height to 1800, to avoid showing the side scrollbar. You can change this height (unfortunatelly iframe does not supports height="100%") to a lower value (eg 500), but if the listing is higher then you'll see the side scrollbar.
As an alternate way you can search and find how you can change the iframe's background color. Honestly, right now, I don't remember. I don't know even if this css definition is supporting. iFrames are hell at all.

Chris

[Paul M]

Inappropriate posts removed. Behave please.

[Halfhidden]

Hi Chris... I'm getting this database error can you throw any light on it please.
I'm running the latest version of clasified and VB 4.1.5L1

Database error in vBulletin 4.1.5:

Invalid SQL:
SELECT * FROM VB_microclassifieds_items WHERE id= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number : 1064
Request Date : Monday, September 19th 2011 @ 11:30:37 AM
Error Date : Monday, September 19th 2011 @ 11:30:38 AM
Script : http://picturepenzance.co.uk/microclassifieds/includes/votes.php
Referrer : http://picturepenzance.co.uk/microclassifieds/includes/votes.php
IP Address : 80.40.134.120
Username : Unregistered
Classname : vB_Database
MySQL Version :


Thanks for your help :)

[maineGuy72]

Hi Chris... I'm getting this database error can you throw any light on it please.
I'm running the latest version of clasified and VB 4.1.5L1



Thanks for your help :)

what did you click to get the error?
can you send the link to where it was?

i tried and clicked on the vote up for my site and it worked fine

[Christos Teriakis]

Hi Chris... I'm getting this database error can you throw any light on it please.
I'm running the latest version of clasified and VB 4.1.5L1



Thanks for your help :)

itemid= ?? ....Missing value. There is a slight possibility to have a server slow down, but if this error still exists, I'll visit your site.

Chris

[Christos Teriakis]

No bugs anymore? I started feeling ....lonelly:D

[RC-Central]

PM sent

[Halfhidden]

Hi Chris thanks for the reply I was out for a few hours and have only just seen this reply.
The error seems to be generated by visitors who seem to be voting (I guess spam bots) I've had about 20 or so today.

Here's a screen shot of the permissions for guests... So I think I'm set up ok.

[Christos Teriakis]

Hi Chris thanks for the reply I was out for a few hours and have only just seen this reply.
The error seems to be generated by visitors who seem to be voting (I guess spam bots) I've had about 20 or so today.

Here's a screen shot of the permissions for guests... So I think I'm set up ok.

I just visited your site and voted without to get any error. So, as you said, most probably are the bots causing this problem. I think that it will be better to add one more permission "Allow votes", so you can prohibit quests from voting.

Chris

[Halfhidden]

I just visited your site and voted without to get any error. So, as you said, most probably are the bots causing this problem. I think that it will be better to add one more permission "Allow votes", so you can prohibit quests from voting.

Chris

I got the error:
I'll send this to you via PM as it contains your IP address in the sql error. And I don't want to publish your IP on the forum :)

If you check out the IP address you'll see yours

[maineGuy72]

I just visited your site and voted without to get any error. So, as you said, most probably are the bots causing this problem. I think that it will be better to add one more permission "Allow votes", so you can prohibit quests from voting.

Chris

good idea
can i also get a pop up window that the admin can write in the classified rules? and info about becoming a premium member?
thanks

[DannyITR]

I'd like to translate the phrases into french. How do I use that xml file to do it? I looked at it but I don't understand.

[hsoen]

No bugs anymore? I started feeling ....lonelly:D

You don't feel lonely.......

After bug fixed, you can add more features and enhance the functions.

People here will give you good feedback and suggestion after using your fantastic mod.

Keep up the good work! Thank you.

[Christos Teriakis]

I got the error:
I'll send this to you via PM as it contains your IP address in the sql error. And I don't want to publish your IP on the forum :)

If you check out the IP address you'll see yours

No, that wasn't error. I mean in code. It was error because I clicked the link in your post before, which was pointing directly to vote.php

Chris

[Halfhidden]

No, that wasn't error. I mean in code. It was error because I clicked the link in your post before, which was pointing directly to vote.php

I see. So is it possible to hide the vote for banned and guests in the next update please :)
This really is a very useful mod indeed.

[Ramsesx]

This URL is wrong (from the older versions). Do you remember where did you found it?

Chris
Don't know if you got an answer to this, if yes please ignore this post.
I found it in the phrase $vbphrase[microclassifieds_no_more]

[JimL]

Is it possible to get a if-statement on the main photo size? if height > width then max height=, else max width=. Problem now is that if you post a picture that's 300x2000 it will look really, really weird.

[hsoen]

All uploads (photos and attachments) are storing in the web space, ignoring your vB settings.

Chris

It would be good if you can create an option for storing all uploads (photos and attachments) in mysql database, just like what vBulletin did.

This option is useful for shared hosting server as the web space (i.e. no of nodes) is limited.

Thank you for your consideration.

[shanef]

5-1-6 I am still getiing pm's about expired ads that have not expired yet

[K4GAP]

Installed on 4.1.5 works great!

I only have one issue. My style is dark and a lot of the settings for this mod appear to have written for light styles. Where can I find the settings to change items to work with a dark style?

[Christos Teriakis]

5-1-6 I am still getiing pm's about expired ads that have not expired yet

Yes, working on the cron file, I found the part of code which send the PMs out of the normal place. I'll post an update in a few hours.

Chris

[Christos Teriakis]

Installed on 4.1.5 works great!

I only have one issue. My style is dark and a lot of the settings for this mod appear to have written for light styles. Where can I find the settings to change items to work with a dark style?

The easiest way is to rename the directory darkgray which exists at microclassifieds/datagrid/skins/ to bluesky. But before you need to rename the existing bluesky to somethingelse ...eg _bluesky

Chris

[maineGuy72]

guess ur not bored anymore chris

[shanef]

Yes, working on the cron file, I found the part of code which send the PMs out of the normal place. I'll post an update in a few hours.

Chris

Thanks for all you work too, can you place a link for those of us that wish to make donation.

[Christos Teriakis]

Thanks for all you work too, can you place a link for those of us that wish to make donation.

Well about donations. I think that more than me, Mike (maineGuy72) deserves them. Supports the thread on the best way and gives me free time to work on the project. So, if its for donation, I highly recomment to donate to him.

As for me, hope in a couple of days (how many times I said it?:D), I'll have my site (http://www.marysclassifieds.com) ready, for those who want to buy the Pro version, or just the Brand Free version.

But in any case, this version will be continue supporting here, and by the chance I want to thank all of you for your nice words.

Chris

[qpurser]

You complained it was quiet here for you now almost all bugs are fixed?

I would like to change the font size of the text in the browsegrid.

Whish variable do I have to set or can it be done in the css?

Thanks
Michael

[DannyITR]

Bug find: When posting a new ad, the tooltip next to "autopost" is the same as the tooltip for "keywords". Just a matter of putting the correct phrase.

[K4GAP]

The easiest way is to rename the directory darkgray which exists at microclassifieds/datagrid/skins/ to bluesky. But before you need to rename the existing bluesky to somethingelse ...eg _bluesky

Chris

That didn't change a thing. The only thing that needs changed is the areas marked with red arrows.

http://www.publicwarriors.com/files/searchbox.png

[Christos Teriakis]

That didn't change a thing. The only thing that needs changed is the areas marked with red arrows.


Everything else is on the css file: microclassifieds/includes/classifieds.css

Chris

[Christos Teriakis]

A new version (5.1.7) is available for download. In this version:

Added a new usergroup permission to allow/disallow use of Ad voting
Added a new setting for the css style that you're using in datagrid (Default now is: bluesky).
Added in cronjob a missing function to remove all bookmarks after Ad deletion
Corrected a bug which was sending wrong PMs, while there was no reason to send them.To upgrade:

Upload all files
Import the product-microclassifieds.xml
Check the usergroup permissions
Check the General settings if you're using a style other than bluesky in datagrid.Chris

[iBaker]

Chris, can you advise when is the datagrid going to be able to be full width on wide screens...thanks for a great effort with this mod...hope to see it at Xenforo very soon

[Christos Teriakis]

Chris, can you advise when is the datagrid going to be able to be full width on wide screens...thanks for a great effort with this mod...hope to see it at Xenforo very soon

I've replied it before, but is better to repost it here. As you maybe know, this is a 3nd party commercial script. Till now I've spent around $400 for the original script, for the support (its extra cost) and some custom modifications. Some of them (eg the search bar below the titles) is custom work and I added it in the free version. Some others that I ordered (and paid) latelly (among them the ability to setup related width instead of fixed as is now), I don't plan to release in the free version.

Sorry, I can accept the idea to share for free my own work, but I don't think that is logic to share for free things that I paid money for them.

Chris

[qpurser]

Keeping an eye on your site every day and can see the progress you made.
Looking forward to see that "special" button that says "PRO version"...:)

Chris,
does the conditional BOTH parties have to write a review before the reviews become visible?
I remember at some point you removed it in an xml file for me.
Just wondering if you kept it that way in the other releases or did you put it back in.

If it is still there could I remove the conditional?
We don't need this for our purposes

Thanks
Michael

[RC-Central]

Great work Chris! Looking good. Any possibilities you will make it able to sell downloadable products instead of tangible items only?? :) That is basically all I need at the current time and other mods are not supported anymore and do not work with 4.1.5.. :(

[fwulfers]

This was mentioned before but not a high priority. When you click on an image and it opens up, it is set to display at a certain size. Looks to be a width of about 550px. It would be nice to display the actual size of the image if it is larger than 550px.

[Christos Teriakis]

This was mentioned before but not a high priority. When you click on an image and it opens up, it is set to display at a certain size. Looks to be a width of about 550px. It would be nice to display the actual size of the image if it is larger than 550px.

In the template microclassifieds_view_item, at the head section (around 60th line), there is:

<script>
$(document).ready(function(){
$("a[rel='lightbox']").colorbox({transition:"none", width:"640", height:"480"});
});
</script>


Try to change it to width:auto, height:auto. If does not works, changed it to fix dimensions, eg width:"800", height:"600"

Chris

[maineGuy72]

chris

next update can you replace the phrases with these. i went and changed all the ' to ` so it appears correctly
thanks

[Christos Teriakis]

Great work Chris! Looking good. Any possibilities you will make it able to sell downloadable products instead of tangible items only?? :) That is basically all I need at the current time and other mods are not supported anymore and do not work with 4.1.5.. :(

The file that I sent you didn't corrected the bug in the microCART?

Chris

[maineGuy72]

when updating to 5.1.7 you must go into usergroups and set permissions again for admins and moderators. it adds another option in there and kicks the moderate option down and resets it to no. just an FWI

[RC-Central]

The file that I sent you didn't corrected the bug in the microCART?

Chris

I never received a file..??.. :confused:

[fwulfers]

Great, that worked. But you have to include quotes so it is: width:"auto", height:"auto"

Hopefully, this will make it to future version updates.

In the template microclassifieds_view_item, at the head section (around 60th line), there is:

<script>
$(document).ready(function(){
$("a[rel='lightbox']").colorbox({transition:"none", width:"640", height:"480"});
});
</script>


Try to change it to width:auto, height:auto. If does not works, changed it to fix dimensions, eg width:"800", height:"600"

Chris

[RC-Central]

How can I change the "Classifieds" name on the navbar to whatever I want to name it??

[RC-Central]

in the auctions option, the word "Reversed" SHOULD be Reserved..

[Christos Teriakis]

I never received a file..??.. :confused:

I sent it the next morning. In any case. Here it is. 99% will fix your problem.

Chris

[maineGuy72]

How can I change the "Classifieds" name on the navbar to whatever I want to name it??

search the mod it has been discussed twice

[RC-Central]

In the auction style ads, it just gives the option to buy, not bid. :confused:

[qpurser]

In the auction style ads, it just gives the option to buy, not bid. :confused:

It was a little confusing for me also but the option is there.
Just when a seller decides to use the "buy now" option it gets confusing as the button "Buy" will show up. Look more to the left where it says: bookmark, contact seller etc.
You will see the option "place bid" there also

[RC-Central]

It would be nice for a button similar to the buy now button for placing a bid. Kind of like ebay, buy it now, place bid and best offer kind of thing. Would be pretty sweet!

[maineGuy72]

Hey Chris, is this your only mod on here or do you have other ones?

[Halfhidden]

Thanks for the update... really love this mod.
Is it possible to incorporate a button in classified that says something like "How to" So that users who don't know how to use the classified can click on that and see a tutorial on how to use the classified?
If you are willing to do this I will put a comprehensive tutorial together in both html and flash video format and sent it to you to add to the downloads so that everyone can enjoy it. It will encourage more people to use this mod. I know I'm trying to coach a few off Facebook where they have a few groups trying to sell stuff but it isn't working for them. They want to come across but there isn't a users tutorial for them.

[rEd86]

Great Mod. Congrats! I tried to search the 82 pages of posts but couldn't find this already answered... We have installed the classified product and are able to create categories and add products for sale. (so the general database connection is working) Strangely, when we click on a the category to see the items for sale in the table/grid, we get the following error inline on the page:

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in [path]/microclassifieds/datagrid/class/phpmydatagrid.class.php on line 24

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in [path]/microclassifieds/datagrid/class/phpmydatagrid.class.php on line 24



https://vborg.vbsupport.ru/attachment.php?attachmentid=133161&stc=1&d=1316727431

We can see products in the "Random Classifieds" and can click on them to view the details. We are at a loss as to why the database connection would only fail in this location.

Thoughts/suggestions?

--Ed

[Halfhidden]

Great Mod. Congrats! I tried to search the 82 pages of posts but couldn't find this already answered... We have installed the classified product and are able to create categories and add products for sale. (so the general database connection is working) Strangely, when we click on a the category to see the items for sale in the table/grid, we get the following error inline on the page:

We can see products in the "Random Classifieds" and can click on them to view the details. We are at a loss as to why the database connection would only fail in this location.

Thoughts/suggestions?

--Ed

Just a thought... looking at that error are you running a sub domain? as in www.mysubdomain.mydomain.com If so that would explain the error.

[rEd86]

Thanks for the quick response Halfhidden. The site is not running of a subdomain.

--Ed

[maineGuy72]

Great Mod. Congrats! I tried to search the 82 pages of posts but couldn't find this already answered... We have installed the classified product and are able to create categories and add products for sale. (so the general database connection is working) Strangely, when we click on a the category to see the items for sale in the table/grid, we get the following error inline on the page:



We can see products in the "Random Classifieds" and can click on them to view the details. We are at a loss as to why the database connection would only fail in this location.

Thoughts/suggestions?

--Ed

are you using mysqli or mysql?
https://vborg.vbsupport.ru/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAA f8%2F9hAAAB30lEQVQ4EZVTSy8DURT%2BZjpm6GhL0pKQphYeC ZF4hIVEWLDowsaCxMJC8AP8AMI%2FsBQWFhKPxMpGbIgFK6vWe 0WoRVOPPihth3vmTm%2FTUuEs7r3zzfnO950zdySw6Nz6%2FKT 9v3EyIknSX8idHiZSBRzcA1fP%2BTK%2FFiDiXBdQo%2BdI%2F p00wklFALI4FRxm2oCl%2FnwypXS7E8gYGZH9YwFSHWvgOUehd 0zsPYJ2CqcqI5lK8pdszXmxICIP1fGHueMXLAcS0BQNTW4bemq Au1gGhmElsy2vAKkWkl12F3RNR2UpJwUjKSisYDZEC44SYKqFw 2SXlLNkQvuZ%2Bn3cwFkkzYppkCWeKwqQMhWhWAly26RMQV%2B hsQLYvXmHqqgwIMOwbo5ooa%2FWzDUXFxuUXmp5ZgjNhWLjIg6 7Wo50sRnwNGC%2Bx4mnwxQ%2BmMp0M7tEHjY8Zv%2BU9V%2FtU mG5N9OFg1CCJxJKn2p1IDcowm6jbHiygnaPzXRw%2FgRQF2IG6 9dAlCSLhNehYKpVx2Iv4PcBUuEQ6Y5P7mdMm1Qj%2BmFg8%2Bo Vg9thE%2FM6bBiu1zC%2B94a1ixSyv5%2B0cDmaJxtP6jh%2Fa ADtii0Nt%2BMR3sqQwJxlMXT4AswBp5lGCosU6eIbPNu0KX0BM mqe8Db%2Bbr8AAAAASUVORK5CYII%3D

[rEd86]

// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
// for slave options just append _slave to your preferred database type.
$config['Database']['dbtype'] = 'mysqli';

[rEd86]

That appears to be the problem. I changed the access type to:

$config['Database']['dbtype'] = 'mysql';

and that table is now loading!

Thanks Mike.

--Ed

[Christos Teriakis]

Hey Chris, is this your only mod on here or do you have other ones?

Currently only this one. Maybe I'll get over another 2 from Mary. microDATING and ForoMail.

Chris

[maineGuy72]

Currently only this one. Maybe I'll get over another 2 from Mary. microDATING and ForoMail.

Chris

what about the microCMS?
is that still hers?

[Christos Teriakis]

what about the microCMS?
is that still hers?


!!!! YOU SPY !!!!!..... Have you droped anything in my laptop and you're watching what I'm doing?:D
Ok. I've also got it. But I had extend it even to support different layouts. Stay tuned. Why? Did you liked to get it?

Chris

[maineGuy72]

!!!! YOU SPY !!!!!..... Have you droped anything in my laptop and you're watching what I'm doing?:D
Ok. I've also got it. But I had extend it even to support different layouts. Stay tuned. Why? Did you liked to get it?

Chris

well i dont have the cms suite and would be interesting to see if my users will like it.

[maineGuy72]

there is no info on it anymore or screen shots so i dont know much about it
want to team up and work the bugs on that one too? lol

[k6rikko]

Hi all :) many sorry about a question of this again. Iam so confused and search and search days for days <.<
Please i hope someone can help me with this. I have uploaded a picture here from the classified browsing view.
It doesnt looks very well on the page.
The white background etc.
Whats the name and where can i find the right css or template to change the dg size (width) and fix it to the white space size ?

Any chance to fix the width each from the selection buttons (like title, type etc) above too?

many many thanks @ all

have a good time

Greets Rikko

http://www.rikko-amuze.com/downloads/classishop.jpg

[Christos Teriakis]

Well, I think that after so many updates, I found some free time to setup my site (http://www.christeris.com). Everybody is welcome there, even if the support for the free version will continue being here.

Chris

[vb.help]

Mary's Classifieds

is there any site map add on file for Mary's Classifieds to use it in vbseo site map add on generation ?

[mgcom]

Well, I think that after so many updates, I found some free time to setup my site (http://www.christeris.com). Everybody is welcome there, even if the support for the free version will continue being here.

Chris

Sweet

Personally i think the newsletter is the most important mod with VB but in Mary's old one you had to do all the work, there is another newsletter (community newsletter) which pulls all the info from your forums to the news letter but its not working and the support is :down:

I'd pay for that if you could stick it on to your to-do list :D

How soon for classifieds pro-version mate ?

[Christos Teriakis]

Sweet

Personally i think the newsletter is the most important mod with VB but in Mary's old one you had to do all the work, there is another newsletter (community newsletter) which pulls all the info from your forums to the news letter but its not working and the support is :down:

Finally I got over all Mary's Mods (even those for vB3), and step by step I'll continue upgrading them. I had no experiance with her ForoMail, but as I seen, for sure it will must be split in 2 parts: Mailinglist manager and Community newsletter. For a first eye I didn't found it not working, but just complicated as is now. I'm planing to use it on my site, so this will be the best way to test it out.

I'd pay for that if you could stick it on to your to-do list :D


How soon for classifieds pro-version mate ?

This evening :)

Chris

[Christos Teriakis]

Mary's Classifieds

is there any site map add on file for Mary's Classifieds to use it in vbseo site map add on generation ?

Officially should be available only in the PRO version, unless if someone post it here for the Free version.

Chris

[k6rikko]

Pleae reply to my posting above about the datagrid width :( Holy VB.org members do me this favor ^^ its really important for me

[maineGuy72]

Pleae reply to my posting above about the datagrid width :( Holy VB.org members do me this favor ^^ its really important for me

https://vborg.vbsupport.ru/showpost.php?p=2248534&postcount=1205

[qpurser]

I just noticed on your site you released version 6.0.
Is this the PRO version now.
Can you tell us a little what the main differences are?

Michael

Nevermind... I purchased the V6 in the mean time.
Very very nice!!!!

[Bergler]

Are you able to charge for a classified with this program?

[Christos Teriakis]

Are you able to charge for a classified with this program?

It follows the usergroup permissions. If you want your users to pay for posting Ads, you must add a usergroup (eg Sellers) and allow only this usergroup to post.

Chris

[Christos Teriakis]

I have uploaded a picture here from the classified browsing view.
It doesnt looks very well on the page.
The white background etc.
You need to edit 2 templates:

1.- microclassifieds_searchgrid
2.- microclassifieds_browsegrid

Find:

<body bgcolor="#FFFFFF">


and replace with:

<body>


or change FFFFFF with your own background color



Whats the name and where can i find the right css or template to change the dg size (width) and fix it to the white space size ?

Has replied many times. You don't need to edit any css, but the classifieds.php.

Search for:

$objGrid-> FormatColumn


It appears 10 times between the lines: 1441-1454. You need to change the values in red as in example below:

$objGrid-> FormatColumn("logo","".$vbphrase["microclassifieds_photo"]."", "25", "0","0","60","center","imagelink:microclassifieds/photos/thumbs/%s:loadAd(%s),id");
$objGrid-> FormatColumn("adtype","".$vbphrase["microclassifieds_grid_adtype"]."", "40", "50", "0", "30", "center", "image:microclassifieds/images/adtype%s.png");
$objGrid-> FormatColumn("title","".$vbphrase["microclassifieds_title"]."", "13", "20", 0, "100","left", "link:loadAd(%s),id");
$objGrid-> FormatColumn("categoryid","".$vbphrase["microclassifieds_category"]."", "5", "1", 0, "70", "left", "related:select name from ".TABLE_PREFIX."microclassifieds_categories where id=%s");
$objGrid-> FormatColumn("userid","User", "5", "30", 2, "5", "left");
$objGrid-> FormatColumn("username","".$vbphrase["microclassifieds_seller"]."", "5", "30", 0, "70", "left", "link:loadUser(%s),userid");
$objGrid-> FormatColumn("newused","".$vbphrase["microclassifieds_condition"]."", "5", "30", 1, "55", "left", "select:1_".$vbulletin->options["microclassifieds_new_item"].":2_".$vbulletin->options["microclassifieds_used_item"]."");
$arrConditions = array("['adtype']==3" => "['buynow']",
"['adtype']!=3" => "['price']"
);
$objGrid-> FormatColumn("starts","".$vbphrase["microclassifieds_post_at"]."", "5", "30", 0, "50", "right");
$objGrid-> FormatColumn("price","".$vbphrase["microclassifieds_price"]."", "5", "30", 0, "60", "right", "money:".$vbulletin->options["microclassifieds_curpre"]."");
$objGrid-> FormatColumn("location","".$vbphrase["microclassifieds_location"]."", "5", "10", "0", "65", "left");


In general is the value before the aligment (eg "center"). Please note that this is a fix width (px) and not related (%).

Chris

[fwulfers]

When someone clicks Report It for a classified ad and fills out the message, what is supposed to happen?

[JimL]

I get this on a new install on a forum upgraded vb3.8.2 to vb4.1.6

Uncaught TypeError: Object #<Object> has no method 'imgAreaSelect'
(anonymous function)usercp_classifieds.php:328
D.event.handle
D.event.add.handle

no users are able to add a selection to the image for thumbnail-cropping. Any ideas?

[Christos Teriakis]

I get this on a new install on a forum upgraded vb3.8.2 to vb4.1.6

Uncaught TypeError: Object #<Object> has no method 'imgAreaSelect'
(anonymous function)usercp_classifieds.php:328
D.event.handle
D.event.add.handle

no users are able to add a selection to the image for thumbnail-cropping. Any ideas?

Please try to re-upload the files, especially those in the directory microclassifieds/includes/
Most probably someone didn't uploaded at all, or uploaded with errors.

Chris

[Christos Teriakis]

When someone clicks Report It for a classified ad and fills out the message, what is supposed to happen?

Nothing changes to the Ad, but the Ad is appears on the moderator options Reported Ads. The moderator then can decide to reject the report or delete the Ad.

Chris