Classifieds System

[watchhead]

9 minutes ago, Adriano Faria said:

Not sure I follow... are you saying you create adverts as JOHN DOE and others are viewing this advert as if anyone else submitted it? Same for questions and offers?

If so, no... obviously that's not what's expected and I can't reproduce it:

This app works just like any other: it stores the IDs of members and show them.

 

Thanks for the speedy reply.

What's happening is:

• When creating adverts or making offers as either of our admin accounts, everything is stored with the correct member_id in the DB
• When creating adverts or making offers with any other account (not part of the admin group) everything is being stored against 1 member_ID regardless of who is creating the advert or making the offer.  In our case, the member ID everything is being stored against is 32767

Hope that makes sense? 

Edited September 11, 2016 by watchhead

[Adriano Faria]

8 minutes ago, watchhead said:

Thanks for the speedy reply.

What's happening is:

• When creating adverts or making offers as either of our admin accounts, everything is stored with the correct member_id in the DB
• When creating adverts or making offers with any other account (not part of the admin group) everything is being stored against 1 member_ID regardless of who is creating the offer or making the offer.  In our case, the member ID everything is being stored against is 32767

Hope that makes sense? 

Still do not make sense and works fine on my live board: http://www.screencast.com/t/wf6ud5WX7

This was develope during 6 months with 11 members testing it. We probably would have noticed something like that.

It seems to be a cache issue on your board, etc. There's nothing in this app that changes ownership of things (adverts, offers, questions, etc.) like there is in others (like the Change Author).

Take a look on your database to see which ID appears in adverts, questions and offers table.

[watchhead]

Just now, Adriano Faria said:

Take a look on your database to see which ID appears in adverts, questions and offers table.

I guessed you might have spotted this during your testing and am sure it's something to do with our environment - just not sure what though?

When myself or the other admin creates an advert or makes an offer, it stores our correct ID in the tables.

When we log on with other accounts, or ask existing members to test, it stores everything they do as member_ID 32767 which doesn't belong to any of the testers.

 

[Adriano Faria]

I suggest you to uninstall the app, clear the cache, then reinstall it.

Sorry, but this makes absolutely no sense at all and I can't reproduce.

[watchhead]

We have tried reinstalling but with the same results.  May I ask what the best way of clearing the cache would be?

[Adriano Faria]

ACP -> System -:> Support -> Something isn't working correctly -> click in Continue button.

When the message " Sometimes badly cached data can cause problems. We have cleared all cached data, please check and see if your problem has been resolved." appears, cache will be cleared. Then you retry adding another advert.

If insists, drop a PM with ACP credentials. I'll take a look today later.

[watchhead]

Will do, thanks Adriano.

[Adriano Faria]

@watchhead, out of curiosity, do you have any other app or plugin that changes the ownership of items posted by users?

[watchhead]

@Adriano Faria

Only the IP Gallery which allows some members to create albums for other members.

The issue with the Classifieds is happening at the point of saving the advert or making the offer.  We have deleted the user that everything was being stored against, uninstalled the app, cleared the cache, reinstalled the app and it's still storing things against the deleted members ID.

Shall I PM you details?

[Adriano Faria]

1 minute ago, watchhead said:

Shall I PM you details?

Sure.

[Adriano Faria]

OK @watchhead, that was really an issue with a column definition. My bad. Your board is fixed and running fine.

I will update the file probably tomorrow with this and couple of other minor issues reported.

[Chris59]

Not sure how the adress is suppose to show up .... have a working google api key and its outofill the adress while i typing but
is there more ?? a map on advert view ?? i only see the adress in category listing view .... 

[Adriano Faria]

18 minutes ago, Chris59 said:

Not sure how the adress is suppose to show up .... have a working google api key and its outofill the adress while i typing but
is there more ?? a map on advert view ?? i only see the adress in category listing view .... 

It should appear below Specs (extra fields) on advert view.

I'll double check and will fix it, if that's the case, in the next version to be released today later.

Edited September 12, 2016 by Adriano Faria

[Adriano Faria]

1 hour ago, Chris59 said:

a map on advert view ??

 

1 hour ago, Adriano Faria said:

I'll double check and will fix it, if that's the case

Fixed in 1.0.1:

[kalin]

In my forum I forbid guests to publish ads, but sometimes when users post an ads, it shows published by guest and then they do not have editing options.

Edited September 12, 2016 by kalin

[Adriano Faria]

1 minute ago, kalin said:

In my forum I forbid guests to publish ads, but sometimes when users post an ads, it shows published by guest and then they have no editing options.

This is probably due to the same problem found here:

Can you confirm if you have member ID = 32767. If not, that's the problem and it was due to bad column definition. It's fixed. I will release 1.0.1 in a couple of hours.

[kalin]

11 minutes ago, Adriano Faria said:

Can you confirm if you have member ID = 32767. If not, that's the problem and it was due to bad column definition. It's fixed. I will release 1.0.1 in a couple of hours.

We do not have user with ID = 32767, but the last user is with ID = 370019

[Adriano Faria]

Just now, kalin said:

We do not have user with ID = 32767, but the last user is with ID = 370019

Yeah, same problem. I've made a mistake and defined the member ID column with a improper type, so it reachs 32767 max and as you don't have that member ID, it shows Guest; otherwise it would display the member ID (32767) name.

If you don't want to wait, drop me a PM with credentials to your ACP and I'll fix it before release 1.0.1

[kalin]

No problem, I'll wait version 1.0.1

[jimkeypro]

I had the old Andy Milne app. Just updated to 4.x so purchased this to replace the old system.

1st problem was the SQL query in the manual

Is that a problem ?

We currently have these tables in the DB

So, we held off on installing the new app pending some advice re process.

Thanks

[Adriano Faria]

1 minute ago, oldlock said:

I had the old Andy Milne app. Just updated to 4.x so purchased this to replace the old system.

1st problem was the SQL query in the manual

Is that a problem ?

We currently have these tables in the DB

So, we held off on installing the new app pending some advice re process.

Thanks

Can you show a print of your core_applications table?

[jimkeypro]

Can't seem to screenshot the table in a way that makes sense. This any good ?

core_applications.sql

[Adriano Faria]

You don't have the entry on core_applications table that I request to delete, althought you have the old tables and I won't delete them... Those tables are kept so you can decide later if you want to delete them.

So you're fine to perform a fresh install of the app.

[jimkeypro]

Hmm. This is what happened ?

[Adriano Faria]

Please, provide ACP access. I'll make it to you.

Via PM.