[crossover.campustours]

Hi,
Thanks a lot for your help. I have followed your advices and everything is ok now.
Bye then from France
Stéphane

[crossover.campustours]

Hi,
Thanks for the tip. I have found 0 ID and I have issued it manually. I have tried to check the option AI in the table si_invoice_items column ID. I can not. SQL error message says “Cannot change column ‘id’: used in a foreign key constraint ‘si_invoice_item_tax_ibfk_2’ of table si_invoice_item_tax
Well, I could not find this named column in the table and I do not know waht to do after this new message.
Regards,
Stéphane

[crossover.campustours]

Hi,
I am used to create the bills with the SI2023 version, php 8.2, mysql 8
I am back with a new bug I can not solve. I do not really understand the meaning of this error message enclosed in my png file.
What shall I have to do please ?
Regards
Stéphane

• This reply was modified 5 months, 3 weeks ago by crossover.campustours.

Attachments:

1. 

   error.png
   

[crossover.campustours]

[UPDATE & GOOD NEWS]

I did a new install from the 2019.2 version in wamp 64. I guess my uwamp was a bit old. I have imported my database from the previous install, everything did well. Then I have updated with 2023 version and have applied the sql patch. Several errors due to foreign keys in the invoice_item_tax table related to invoice_items table have been solved as I have deleted them. Made the update, everything is well and I have the 2023 version ! The design is not broken anymore.

Regards

Stéphane

• This reply was modified 6 months ago by crossover.campustours.

[crossover.campustours]

Hi,
I have tried your tips but I could not achieve to a good updated version 🙁 I am not good enough. Well I have tried to install SI 2023 with Wamp 64. It did well. It has told me updates need to be done from the #330 or #331 but sql updater did not be able to do these updates.
So I have begun with the 2023 version but I am frustrated I could not be able to solve my problems even if you have taken precious time to help.
I have uploaded the last sql version enclosed to this message. More over it says to check error.log but I do not know where the file is situated.
Well…
Regards
Stéphane

Attachments:

1. crossover.zip

[crossover.campustours]

Hello,
Thanks for the tip and the time you took to have a look. Unfortunatly as I copy paste the sql command to alter table si_invoice_items MySql returns an empty result where no line needs to be altered.
Need a bit more help please,
Regards
Stéphane

[Author]

Posts