Forum Replies Created
-
AuthorPosts
-
March 18, 2021 at 7:19 am in reply to: Install a db 2011 si version with 2019 or 2020 si version #1406RRowleyParticipant
A user has encountered this issue before. The problem is the value in the database for the si_system_defaults table on the row with the name of “Delete”, is not correct. It likely contains a Y or N, or a T or F. Change this value manually to be 1 or 0 respectively.
March 18, 2021 at 5:53 am in reply to: Install a db 2011 si version with 2019 or 2020 si version #1402RRowleyParticipantYou have to load and successfully run the master_2019.2 update before you can load the master_2020 version. Please make sure that you process it in this order.
March 18, 2021 at 5:46 am in reply to: Install a db 2011 si version with 2019 or 2020 si version #1398RRowleyParticipantIn the si_system_defaults table, find the row with “name = delete.” The value in it needs to be a 0 or 1. It probably has a “T” or “F”, or “Y” or “N”. Change it to “1” or “0” respectively.
- This reply was modified 3 years, 1 month ago by RRowley.
RRowleyParticipantOK, lets just set the basics in the custom.config.ini file. Retype your lines to make sure there are no weird characters in them. Also, there is an updated Config.php file in the zip below. It checks for the false return that you are getting and shows a generic error rather stack dump.
[production] databaseAdapter = pdo_mysql databaseUtf8 = true databaseHost = yourhostsetting databaseUsername = yourdbusername databasePassword = "yourdbpassword" databaseDbname = yourdbname databasePort = 3306 authenticationEnabled = true authenticationHttp = exportSpreadsheet = xls exportWordProcessor = doc exportPdfDefaultFontSize = 12 exportPdfPaperSize = Letter exportPdfLeftMargin = 15 exportPdfRightMargin = 15 exportPdfTopMargin = 15 exportPdfBottomMargin = 15 versionName = 2020.0.12 versionUpdateDate = 20210128 localLocale = en_US localCurrencyCode = USD localPrecision = 2 emailHost = youremailsmtphost emailSmtpAuth = true emailUsername = youremailusername emailPassword = youremailpassword emailSmtpPort = yoursmtpport emailSecure = yoursecuresetting emailAck = youracksetting(true/false) emailUseLocalSendmail = youruserlocalsendmailsetting(true/false) encryptionDefaultKey = this_is_the_encryption_key_change_it nonceKey = this_should_be_random_and_secret_so_change_it nonceTimeLimit = 3600 debugLevel = All debugErrorReporting = E_ERROR phpSettingsDateTimezone = yourdatetimezonesetting phpSettingsDisplayStartupErrors = 1 phpSettingsDisplayErrors = 1 phpSettingsLogErrors = 1 phpSettingsErrorLog = tmp/log/php.log ; Logs in tmp/log/si.log. Set to the desired level for log detail. ; The lower the number, the more information will be logged. ; DEBUG(100),INFO(200),NOTICE(250),WARNING(300),ERROR(400),CRITICAL(500),ALERT(550),EMERGENCY(600) loggerLevel = DEBUG ; Explicitly confirm delete of line items from invoices? (yes/no) confirmDeleteLineItem = no
Attachments:
RRowleyParticipantChange line 45 and 46 of the Inc/Claz/Config.php file from:
$fooType = getType($config[$section]);
var_dump("gettype {$configFile}[{$section}]: {$fooType}");
to
$fooType = getType($config);
var_dump("gettype {$configFile}: {$fooType}");
and run the test again.
- This reply was modified 3 years, 1 month ago by RRowley.
RRowleyParticipantNot sure what is happening. Your custom.config.ini parses correctly for me once I fill in valid database settings. So we need to troubleshoot to drill down to the problem. Attached is a zip file containing the Config.php file. Store this in your Inc/Claz folder over the existing version of the file. After doing this, do any action (display the login screen, etc.) and there will be information displayed at the top of the browser screen. Copy this information to a response to this this message. Show the info in a CODE section so nothing get misinterpreted.
- This reply was modified 3 years, 1 month ago by RRowley.
Attachments:
RRowleyParticipantMake a copy of your custom.config.ini file. Then obfuscate the passwords and personal info in the custom.config.ini file, and zip it. Attach the zip file to a response to this message.
RRowleyParticipantPlease zip and attach your tmp/log/php.log file in a response to this message.
February 25, 2021 at 2:49 pm in reply to: Invoices 2000 – Show “Owing” values different on Quick View to Print Preview #1375RRowleyParticipantThe values I requested contain no secure or secret information. That is why I was so specific in what I asked for. You shouldn’t have any concern with sharing these on this forum.
RRowleyParticipantWhile this inquiry is in process, copy the public/data.json file to zip and attach. Next, in phpMyAdmin, access the si_system_defauts table and export it to zip and attach. Then make a zip file with the data.json, exported si_system_detauls sql file and the templates/default/products/manage.tpl files. Attach the zip file to a response to this message.
February 21, 2021 at 3:54 pm in reply to: Invoices 2000 – Show “Owing” values different on Quick View to Print Preview #1368RRowleyParticipantGive me an export of the si_preferences file and the localLocale, localCurrencyCode and localPrecision settings from the custom.config.ini file. I’ll see if I can replicate your set up.
RRowleyParticipantSounds like you have a definition of “fun” similar to mine. Good luck.
February 19, 2021 at 6:23 pm in reply to: Invoices 2000 – Show “Owing” values different on Quick View to Print Preview #1364RRowleyParticipantFind the invoice in the si_invoices table and set the owing field to 799. That should correct this.
RRowleyParticipantI forgot to a a
COMMIT;
line at the end of the sql file. So I’ve attached an update version with this message.Attachments:
RRowleyParticipantSorry to tell you this, but you probably have a data base that does not have the proper foreign keys enabled. It will work, but you won’t be protected from orphaned records.
The 318 error you had is telling you that you have orphaned records in your database. This is what was in your log:
FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE ------------------------ ------------------ ----------------------- --------- ------------- user domain_id user_domain id 4 user domain_id user_domain id 3 user domain_id user_domain id 2
Basically this is telling you that there are three records in the si_user table with the domain_id set to 2, 3 and 4 which do not have parent records for those domains in the si_user_domain table. The best solution is to create these records in the si_user_domain table and run the master_2019.2 installation again; assuming you can back up that far.
If you can load back to where you were prior to loading master_2020, this is what you should do. This way, the foreign key constraints implemented in patch 318 will succeed and every thing will be hunky dory.
Otherwise, you can make the fix above and import the sql file in the attach zip file which hopefully, will apply all the foreign key constraints to you master_2020 database.
Let me know how it turns out.
Attachments:
-
AuthorPosts
Recent Comments