Support

Support is part of Event Gallery Extended.

Please get a subscription if you need support. Feel free to use the ticket system or the contact form for reporting defects or pre-sale questions. Make sure you're logged in in order to be able to create a new ticket.

For general information you can also jump to the manual.

Subscribe now!

#3255 setting start value of order id

Posted in ‘Event Gallery Extended’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by ChristianW-ST on Friday, 31 August 2018 08:13 UTC

Monday, 20 August 2018 12:45 UTC

ChristianW-ST
Hello,

i want to know, how i can set the start value of the order id.
By testing the component, i made some orders and the order id was counting up automatically. Now i want to set the start value of the order id manually to start.

Thanks,
Christian

Monday, 20 August 2018 18:12 UTC

sbluege
Hi,

you need to modify the database table.

ALTER TABLE #__eventgallery_order AUTO_INCREMENT = 1;


Before you can do this, you need to delete all orders.

Thursday, 30 August 2018 16:47 UTC

ChristianW-ST
I tried it, but the Order-ID (= documentno in table "eventgallery_order") does not start at number 1. The number continues counting at the previous value.

Friday, 31 August 2018 07:36 UTC

sbluege
Well..... wrong table. Try to truncate the table #__eventgallery_sequence and reset the auto increment value:

ALTER TABLE #__eventgallery_sequence AUTO_INCREMENT = 1;


This should work. Deleting all orders is a good idea anyway since this change will cause overlapping documentno values.

Friday, 31 August 2018 08:13 UTC

ChristianW-ST
Perfect, that was the solution!