Jump to content

Classifieds System

Featured Replies

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 by watchhead

  • Replies 2.1k
  • Views 181.4k
  • Created
  • Last Reply

Top Posters In This Topic

Most Popular Posts

  • UPDATE Classifieds 2.0 with new shipment feature will be release (with invisionHQ black friday offers) on 23 November 2019. 

  • InvisionHQ
    InvisionHQ

    Hi guys, I will try to do my best to continue the excellent work already done on the app by @Adriano Faria.

  • A little update on the roadmap of this app: 2.1 Advert filters #1 (prices, types, conditions) (Feb 2020) 2.2 Feedback system (March 2020) 2.2 MyClassifieds Page (March 2020) 2.3 Advert filters #2

Posted Images

  • Author
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.

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.

 

  • Author

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.

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

  • Author

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.

Will do, thanks Adriano.

  • Author

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

@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?

  • Author
1 minute ago, watchhead said:

Shall I PM you details?

Sure.

  • Author

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.

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 .... 

2016-09-12_11-39-26.jpg

  • Author
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 .... 

2016-09-12_11-39-26.jpg

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 by Adriano Faria

  • Author
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:

Capturar.png

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.

screenshot-www.kaldata.com 2016-09-12 14-29-53.png

Edited by kalin

  • Author
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.

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

  • Author
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

No problem, I'll wait version 1.0.1 ^_^

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

classifieds1.PNG

Is that a problem ?

We currently have these tables in the DB

classifieds.PNG

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

Thanks

  • Author
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

classifieds1.PNG

Is that a problem ?

We currently have these tables in the DB

classifieds.PNG

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?

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

core_applications.sql

  • Author

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.

Hmm. This is what happened ?

class.PNG

  • Author

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

Via PM.

Recently Browsing 0

  • No registered users viewing this page.