April 8, 2021 at 9:14 am #1466
I use to edit invoices with that great tool ! RRowley has helped me a lot for Radio Campus Tours. We can use the SI 2020 with pleasure.
I am also used to use SI as I am producing DJ set. Unfortunatly the SI 2011 does not want to show me the old invoices. I do not know what to do to solve that bug and to update to SI 2020. I can see my guests, the articles. I can see the invoices in my db. I need a bit help please. I use php 5.6.18 and mysql 5.7.11.
April 8, 2021 at 3:13 pm #1468
- This topic was modified 1 week, 1 day ago by radiocampustours.
If you are running SI 2011, you should try to update to master_2019.2. I should work with your level of PHP. The update is pretty straight forward.
- Backup your database
- Copy your SI in to another backup directory.
- Delete all the sub-directories in your SI directory.
- Unzip the master_2019.2 zip file content into your empty SI directory
- Copy the
config/custom.config.phpfile from your copy of the old SI into the
configdirectory of your existing SI directory. If you don’t have a
custom.config.php, copy the
config/config.phpafter renaming it to
- Run SI. I should show you that there are a number of updates that need to be applied. Do this.
April 12, 2021 at 11:51 am #1476
You might be stopped at the update that adds foreign key support if you have orphaned records in your database. If so, look at the instructions in the error message and see if you can resolve it. If not, get back to me.
I just did what you told me. I have an error concerning Claz. I embed an image to explain. What should I do next please ?
Attachments:April 13, 2021 at 9:38 am #1479
For SI master_2019.2, you need to be on PHP 7.2 at a minimum. PHP 7.4 preferably and 7.4 required for SI master_2020. Any reason you can’t do this?April 14, 2021 at 5:07 am #1487
Thx for the tip. As I run with php 7.2.7 / Mysql 5.7.11 I can access to the patches page. As I click on patch I have an error “SqlPatchManager::runSqlPatch() error. See error log for more information.” Here enclosed my php.log
What should I have to do to fix that error please ?
Attachments:April 15, 2021 at 5:50 am #1489
Check the content of your si_index table. There is probably only one record in it but could be more. Make sure each record contains a numeric 0 in the sub_node_2 column. It is probably blank but should be 0.April 16, 2021 at 8:10 am #1490
I did add 0 in the sub_node_2 column as it was blank. I clicked on patch the I still have this error “SqlPatchManager::runSqlPatch() error. See error log for more information.” I enclose the php.log and I still do not know what I should have to do.
- This reply was modified 2 hours, 46 minutes ago by radiocampustours.
Attachments:April 16, 2021 at 8:57 am #1493
The error you are getting is:
[14-Apr-2021 14:02:04 Europe/Paris] SqlPatchManager::runSqlPatch() - PdoDb - query(): Execute error. See error_log. [16-Apr-2021 17:05:34 Europe/Paris] PdoDb - debugger(): ALTER TABLE <code>si_invoices</code> ADD UNIQUE INDEX <code>UniqDIB</code> (<code>index_id</code>, <code>preference_id</code>, <code>biller_id</code>, <code>domain_id</code>), ADD INDEX <code>IdxDI</code> (<code>index_id</code>, <code>preference_id</code>, <code>domain_id</code>); [16-Apr-2021 17:05:34 Europe/Paris] PdoDb - query(): Execute error.Array (  => 42000  => 1067  => Invalid default value for 'date' )
If you look at the si_invoices structure, you should see that the date column is set to NULL = NO and Default of 0000-00-00 00:00:00. You need to make sure that zero dates are allowed in your database. Do this by commenting out the “sql_mode=” in the my.ini file.
For reference, make the current setting for this value into a comment by adding a # at the front of the line. An example of what this line might be set to is, sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION.
After you make this change, restart your mysql server and access SI again.
- This reply was modified 1 hour, 59 minutes ago by RRowley.
- You must be logged in to reply to this topic.