[Fuquar7]

Further progress, but stuck at this point

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint in /simpleinvoices/Inc/Claz/PdoDb.php:1294 Stack trace: #0 /simpleinvoices/Inc/Claz/PdoDb.php(1294): PDOStatement->execute() #1 /simpleinvoices/Inc/Claz/SqlPatchManager.php(145): Inc\Claz\PdoDb->query() #2 /simpleinvoices/Inc/Claz/SqlPatchManager.php(215): Inc\Claz\SqlPatchManager::runSqlPatch() #3 simpleinvoices/index.php(238): Inc\Claz\SqlPatchManager::runPatches() #4 {main} thrown in /simpleinvoices/Inc/Claz/PdoDb.php on line 1294

[Fuquar7]

I’ve made progress, I now have problems with
SqlPatchManager::runSqlPatch() error. See error log for more information.

the FOREIGN KEY TABLE or some values in those seem to be at issue. I really only need to know if I can just delete the date or modify

Attachments:

1. php.log-2.txt

[Fuquar7]

Excellent! I manually changed currency code in the database on the four of five entries and I now have a nice display of everything.
Thank you for your hard work! Much appreciated!!

[Fuquar7]

I have run the update and I still do not see the general listing of invoices, when I use inspect on Chrome these are the errors I receive



index.php?module=inv…ces&view=manage:390 Uncaught RangeError: Invalid currency code : 
    at new NumberFormat (<anonymous>)
    at render (index.php?module=inv…ces&view=manage:390)
    at jquery.dataTables.min.js:18
    at Object.b.fnGetData (jquery.dataTables.min.js:12)
    at B (jquery.dataTables.min.js:17)
    at Ia (jquery.dataTables.min.js:15)
    at ob (jquery.dataTables.min.js:67)
    at T (jquery.dataTables.min.js:31)
    at jquery.dataTables.min.js:49
    at i (jquery.dataTables.min.js:36)
favicon.ico:1 GET https://fuquar.com/images/favicon.ico 500
index.php?module=invoices&view=manage:1 Unchecked runtime.lastError: The message port closed before a response was received.
index.php?module=invoices&view=manage:1 Error handling response: TypeError: Cannot read property 'loggedOut' of undefined
    at chrome-extension://kcnhkahnjcbndmmehfkdnkjomaanaooo/contentscript.js:167:137

​

• This reply was modified 3 years, 8 months ago by Fuquar7.
• This reply was modified 3 years, 8 months ago by Fuquar7.

[Fuquar7]

What folders/files do I need to update?

I’ve replaced

Inc/Claz
library
include

with no change

[Fuquar7]

That worked, Thank you!

minor problem now no invoice listing it’s stuck on loading

[Fuquar7]

string(38) "file config/custom.config.ini exists: "
bool(true)
string(41) "gettype config/custom.config.ini: boolean"
<br />
<b>Fatal error</b>:  Uncaught TypeError: Typed property Inc\Claz\Config::$customConfig must be array, null used in /homepages/36/d249534786/htdocs/fuquar.com/simpleinvoices_20210315_Work_in_Progress_2020_update/Inc/Claz/Config.php:47
Stack trace:
#0 /homepages/36/d249534786/htdocs/fuquar.com/simpleinvoices_20210315_Work_in_Progress_2020_update/Inc/Claz/Setup.php(26): Inc\Claz\Config::init('production', true, 'config/custom.c...')
#1 /homepages/36/d249534786/htdocs/fuquar.com/simpleinvoices_20210315_Work_in_Progress_2020_update/index.php(92): Inc\Claz\Setup->__construct('production', true)
#2 {main}
  thrown in <b>/homepages/36/d249534786/htdocs/fuquar.com/simpleinvoices_20210315_Work_in_Progress_2020_update/Inc/Claz/Config.php</b> on line <b>47</b><br />

Hopefully this will help. I am nothing but a script kitty, this is a bit beyond my skillset.

[Fuquar7]

`string(38) “file config/custom.config.ini exists: ”
bool(true)
string(50) “gettype config/custom.config.ini[production]: NULL”
<br />
<b>Fatal error</b>: Uncaught TypeError: Typed property Inc\Claz\Config::$customConfig must be array, null used in /homepages/36/d249534786/htdocs/fuquar/simpleinvoices/Inc/Claz/Config.php:47
Stack trace:
#0 /homepages/36/d249534786/htdocs/fuquar/simpleinvoices/Inc/Claz/Setup.php(26): Inc\Claz\Config::init(‘production’, false, ‘config/custom.c…’)
#1 /homepages/36/d249534786/htdocs/fuquar/simpleinvoices/index.php(92): Inc\Claz\Setup->__construct(‘production’, false)
#2 {main}
thrown in <b>/homepages/36/d249534786/htdocs/fuquar/simpleinvoices/Inc/Claz/Config.php</b> on line <b>47</b><br />

[Fuquar7]

As requested see attached

Attachments:

1. custom.config.zip

[Fuquar7]

That file [php.log] does not exist in that directory.

I went through the entire update process a second time and I am still getting the same errors.

Fatal error: Uncaught TypeError: Typed property Inc\Claz\Config::$customConfig must be array, null used in /homepages/36/d249534786/htdocs/fuquar/simpleinvoices/Inc/Claz/Config.php:43 Stack trace: #0 /homepages/36/d249534786/htdocs/fuquar/simpleinvoices/Inc/Claz/Setup.php(26): Inc\Claz\Config::init(‘production’, true, ‘config/custom.c…’) #1 /homepages/36/d249534786/htdocs/fuquar/simpleinvoices/index.php(92): Inc\Claz\Setup->__construct(‘production’, true) #2 {main} thrown in /homepages/36/d249534786/htdocs/fuquar/simpleinvoices/Inc/Claz/Config.php on line 43

when dealing with 2019.2 I have some strange behavior that may or may not be related [see attached]

• This reply was modified 3 years, 9 months ago by Fuquar7. Reason: better screen shots

Attachments:

1. 

   no-invoice-listing-2019.2.png
   

2. 

   strange-products-list-with-old-total-style-items-listed.png
   

3. 

   no-invoice-listing-2019.2-1.png
   

4. 

   strange-products-list-with-old-total-style-items-listed-1.png
   

[Fuquar7]

I have searched and have found nothing that applies in this fourm
What I would like to have the ability to search the notes for line items and the “notes” sections on invoices.
I use a generic line item “Labor” and I detail what work was completed on the job. There are times I need to look up an old invoice based on the job description. Currently I login to my database back end and search that way.

Is there a solution or some sample code that I could assemble (I’m a script kitty) to make it easier to accomplish the same thing?

Additionally is there anyway to add (for my purposes) a “invoice summary” item when on the invoice listing page? Possibly replacing the “biller” column?

I am a commercial contractor and I have several big maintenance contracts so I generate hundreds of invoices for one location at times. It would be helpful if there were a way to display a summary.

Sorry if this is in the wrong place I did not know where else to post.

• This reply was modified 5 years, 5 months ago by Fuquar7. Reason: email notifications

[Author]

Posts