Strange Listing ID question

[zooi +]

What version of 68 Classifieds are you running?
v4.2.1 Developer

What template are you using?
Sigma

Please describe in detail the issue you are having:

I noticed by accident that the listing id in the admin section is one lower then in the emails sent to the owner of the listing. For example. If I place as registered visitor a listing which has a listing id 60 in the admin section (as adminstrator) then in the mail I received (as registered visitor) it as listing id 61?

Some body any idea what can cause this difference?


Thank you in advance for your reply.

Zooi

[Blair +]

Yeah - that's really strange. I doubt the problem lies with the database server (which is ultimately responsible for assiging listing ID's) so my assumption is that some PHP function is modifying the ID when the email is sent out. Do you notice it anywhere else within your site?

Please send submit a support ticket with access (ftp and admin) info.
Thanks-

[zooi +]

which files do I have to check the php functions?

Furthermore I checked my database and I noticed a possible error? "The following indexes appear to be equal and one of them should be removed: PRIMARY, id"?


Indexen: Sleutel naam Type Kardinaliteit Actie Veld
PRIMARY PRIMARY 0 id
title INDEX Geen title
owner INDEX Geen owner
id INDEX Geen id
display INDEX Geen display
price INDEX Geen price
section INDEX Geen section
expiration INDEX Geen expiration
The following indexes appear to be equal and one of them should be removed: PRIMARY, id

Is it correct that C68 use twice an id in the class_listings? or shall I remove PRIMARY PRIMARY 0 id ?

Further I noticed in the database that orderID is indeed one higher then id.
I will delete all my ads and start all over to see what happens (Site is still in test mode)

I deleted all my listings but no change. Maybe it is normal that in the database orderID is different from id but in that case in the admin section and in the notification mail orderID should be shown instead of id!

suggestions and ideas are welcome

[zooi +]

Ticket send to support

[Blair +]

Resolution:

The ORDER ID used to identify orders don't necessarily align with LISTING IDs.

THANK YOU!!!!