Bug deleted listing brings mysql error

[Darkside]

When an listing is canceled, where a thread was created for, a link is included in this message.

When I click on the link, there is a database error because the listing do not exist anymore.

It would be better if you could adjust the ACP, as long expired or deleted Auctions may still be displayed
Thereafter, these should then be deleted from the database.
For this purpose, a prune of the Forum was to take place.
This is but the ACP for forums adjust (delete messages older than xxx days)

 

[Mokonzi]

When an listing is canceled, where a thread was created for, a link is included in this message.

When I click on the link, there is a database error because the listing do not exist anymore.

It would be better if you could adjust the ACP, as long expired or deleted Auctions may still be displayed
Thereafter, these should then be deleted from the database.
For this purpose, a prune of the Forum was to take place.
This is but the ACP for forums adjust (delete messages older than xxx days)

Thanks Darkside. Do you have a link to an example for me to check out?

 

[Darkside]

Thanks Darkside. Do you have a link to an example for me to check out?

sure .....

Neue Suche Anzeige: Suche Markierer

this is the MySQL Error Msg :

Database error in vBulletin 4.2.3:

Invalid SQL:

SELECT
COUNT( * ) AS count
FROM dbtech_classifieds_offer AS o
WHERE o.listingitemid =;

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 '' at line 4
Error Number : 1064
Request Date : Thursday, July 23rd 2015 @ 03:31:19 PM
Error Date : Thursday, July 23rd 2015 @ 03:31:19 PM
Script : Mönchengladbach Executioners Database Error
Referrer : Neue Suche Anzeige: Suche Markierer

 

[Mokonzi]

sure .....

Neue Suche Anzeige: Suche Markierer

this is the MySQL Error Msg :

Database error in vBulletin 4.2.3:

Invalid SQL:

SELECT
COUNT( * ) AS count
FROM dbtech_classifieds_offer AS o
WHERE o.listingitemid =;

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 '' at line 4
Error Number : 1064
Request Date : Thursday, July 23rd 2015 @ 03:31:19 PM
Error Date : Thursday, July 23rd 2015 @ 03:31:19 PM
Script : Mönchengladbach Executioners Database Error
Referrer : Neue Suche Anzeige: Suche Markierer

Thanks Darkside. Can you confirm for me what type of listing it was? Auction, But-it-Now or Wanted?

 

[Darkside]

Thanks Darkside. Can you confirm for me what type of listing it was? Auction, But-it-Now or Wanted?

Wanted

 

[Mokonzi]

Wanted

Thanks Darkside. I'll see if I can get a fix sorted over the weekend.

 

[Darkside]

I have more errors found :

in ACP the Poster Username and Email Sender is changed to the User-ID





the E-Mail becomes like this :



take a look at : von / from ...... 3-
it should be the Postername


In view Listing is the Listing Control Menu



which may not be visible to the Admin

In Seller Information
when I click on the Seller name it should show me the Feedback and not the Listings

Feedback :

Feedback as Seller



in From/Price it should be Seller and not Buyer

Feedback as Buyer



in From/Price is the same as above

All Feedback



here is it the last what is wrong...... here should it Seller and not Buyer

Feedback left for others



it is the same as above ... the last must be Seller and not Buyer

 

[Mokonzi]

I have more errors found :

in ACP the Poster Username and Email Sender is changed to the User-ID

View attachment 6548

View attachment 6549

the E-Mail becomes like this :

View attachment 6550

take a look at : von / from ...... 3-
it should be the Postername

The email will be sent out using the system admin system, not the user's email. That is working as intended. The Username is used for internal PMs only.

In view Listing is the Listing Control Menu

View attachment 6551

which may not be visible to the Admin

I'm not sure what you are getting at here? Can you explain your concern more?

In Seller Information
when I click on the Seller name it should show me the Feedback and not the Listings

Feedback :

Feedback as Seller

View attachment 6552

in From/Price it should be Seller and not Buyer

Feedback as Buyer

View attachment 6553

in From/Price is the same as above

All Feedback

View attachment 6554

here is it the last what is wrong...... here should it Seller and not Buyer

Feedback left for others

View attachment 6555

it is the same as above ... the last must be Seller and not Buyer

I'll check out these issues on my local install and see what's happening. Regarding the Seller Information, I'm thinking it might be intended, but I need to check through my notes to make sure.

Matt

 

[Darkside]

The email will be sent out using the system admin system, not the user's email. That is working as intended. The Username is used for internal PMs only.

are you sure ??



as I wrote in my post above is the username replaced by the id

I'm not sure what you are getting at here? Can you explain your concern more?

Look at the red to labeled
when I click as Admin any Link in this section, it gives me permission error

Update : after a cache repair it is working. The Admin can use the Links in the Linsting Control Menu

I'll check out these issues on my local install and see what's happening. Regarding the Seller Information, I'm thinking it might be intended, but I need to check through my notes to make sure.

Matt

 

[Mokonzi]

"The username of the user who is will be the 'sender' of any emails and PMs from the Classifieds system." That's what the setting says in English. It should be a username and not a UserID. From memory, it uses the system email, but adds the correct username in for Emails. For PMs, it sends it from that user's account.

Thanks for the update on the Admin stuff. I'm still checking the last bit you quoted.

 

[Mokonzi]

Ok, I've seen it is affecting DBTech as well the mismatch of Buyer/Seller. Can you post that in a separate thread linking back to these posts so I can keep track of it. I've noted as well that it's not always bringing all the feedback results it should be. It might need a bit more checking to see why.

Thanks for helping with this Darkside.

Matt

 

[Darkside]

"The username of the user who is will be the 'sender' of any emails and PMs from the Classifieds system." That's what the setting says in English. It should be a username and not a UserID. From memory, it uses the system email, but adds the correct username in for Emails. For PMs, it sends it from that user's account.

Thanks for the update on the Admin stuff. I'm still checking the last bit you quoted.

And that is not given.
When I enter the Username : "Auktionsmaster" it will be replaced by the User-Id after saving the settings. Auktionsmaster has the User-Id "3"
In PM´s it shows right .... it is only for Emails

 

[Mokonzi]

And that is not given.
When I enter the Username : "Auktionsmaster" it will be replaced by the User-Id after saving the settings. Auktionsmaster has the User-Id "3"
In PM´s it shows right .... it is only for Emails

Thanks Darkside, I'll take a look today to see if I can trace the problem.

 

[Mokonzi]

Everything posted in this thread has been fixed either in version 1 or in version 2. Closing this thread now.

 

[Mokonzi]

Hello Darkside,

This ticket has now been closed with the status Fixed.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!