Order Comments Status/Update Boilerplate

mvstudio:

I've encountered another issue.

In orders.php the textarea isn't getting populated with the predefined comments. No error logs.

Any ideas?

The area is updated with JavaScript. Check your browser console for errors.
I am not in able to fix the module this week, because I am on a holiday, but after that I will fix it. You can also create a pull request or issue on GitHub, so I can update the module easier.

I thought I posted the error I got in the console, but now I see I didn't.

This is the error I'm getting - SyntaxError: unterminated string literal - which points to these lines in the code

      echo "{value : '" . $value['id'] . "', comment : '" . $value['content'] . "'}";
    } else {
      echo "{value : '" . $value['id'] . "', comment : '" . $value['content'] . "'},";

I also had ' in the comment sample I generated. I was able to get rid off the other errors by changing the words don't to do not and so on. I'm assuming the problems is with the sanitize?

Thank you for looking into it.

mvstudio:

Hello. I know this thread is a bit old, but the module seems promising and could be quite useful.

I've downloaded this plugin from https://github.com/Zen4All-nl/Zen-Cart-Order-Comments-Boilerplate

I too get the same error and more when trying to access the orders.php page. Actually the orders.php page goes blank.

Checking the database via phpAdmin the tables are not being created. The installer doesn't seem to be running. I was able to create the tables nonetheless, yet I still get errors in the admin area. Nothing is inserted in configuration_group in the database either.

This is the error I keep getting when trying to access the order_comment_boilerplate.php page. All files are in the correct place. I'm using v1.5.5e.

[04-May-2018 16:20:18 America/Denver] Request URI: /ADMIN/order_comment_boilerplate.php, IP address: xxxxxx
#1 trigger_error() called at [/home/koolwedd/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/public_html/pluMp-nRJ-crosS/includes/classes/split_page_results.php:40]
#5 splitPageResults->__construct() called at [/public_html/pluMp-nRJ-crosS/order_comment_boilerplate.php:306]

[04-May-2018 16:20:18 America/Denver] PHP Fatal error: 1146:Table 'XXXXX.order_comments_content' doesn't exist :: select count(*) as total FROM order_comments oc, order_comments_content occ WHERE oc.comment_id = occ.comment_id AND occ.language_id = '1' ==> (as called by) /public_html/pluMp-nRJ-crosS/includes/classes/split_page_results.php on line 40 <== in /public_html/includes/classes/db/mysql/query_factory.php on line 167

Any idea what could be the issue?

Thank you !
This error has been fixed,by adding DB_PREFIX to the table defines.

Design75:

This error has been fixed,by adding DB_PREFIX to the table defines.

Thank you. I did solve this one. The last error I got - SyntaxError: unterminated string literal - is the one I'm unable to. It seems any comma, period, etc added to the comment itself affects the display of the comment in the textarea box generating that error. Perhaps the sanitizer? I tested a regular text comment without periods, commas, etc, and the comment gets populated just fine in the textarea box.

Thank you for taking the time to look into it. I appreciate it.

mvstudio:

Thank you. I did solve this one. The last error I got - SyntaxError: unterminated string literal - is the one I'm unable to. It seems any comma, period, etc added to the comment itself affects the display of the comment in the textarea box generating that error. Perhaps the sanitizer? I tested a regular text comment without periods, commas, etc, and the comment gets populated just fine in the textarea box.

Thank you for taking the time to look into it. I appreciate it.
This should be fixed to.

Thank you for the fix! It's much appreciated.

Is there any way to allow line breaks even on plain text? When the comment is entered it saves it as a continuous line of text.

mvstudio:

Thank you for the fix! It's much appreciated.

Is there any way to allow line breaks even on plain text? When the comment is entered it saves it as a continuous line of text.
I'll look into it. This mod only started as a proof of concept. So alot of improvement is possible.

Oh, I get it! Thank you! It's a wonderful addition to any store for sure.
Thank you for looking into it =)

Except for the documentation, I think most work is done.
Please test using https://github.com/Zen4All-nl/Zen-Cart-Order-Comments-Boilerplate/archive/master.zip, and report any issues.

When the documentation is done, I'll publish version 1.0 to the downloads section.

Design75:

Except for the documentation, I think most work is done.
Please test using https://github.com/Zen4All-nl/Zen-Cart-Order-Comments-Boilerplate/archive/master.zip, and report any issues.

When the documentation is done, I'll publish version 1.0 to the downloads section.

BRILLIANT!!! I'll install, test and get back with any findings. Thank you so much and have a great weekend! =)

I'm back after a full weekend of testing. So the plugin works as it should. No errors, no blank pages and no error logs. The improvements you made are also really nice! Thank you so much for taking the time to work on it!!
It would be nice to find this in the plugin section for easy download. Just saying! :D

mvstudio:

I'm back after a full weekend of testing. So the plugin works as it should. No errors, no blank pages and no error logs. The improvements you made are also really nice! Thank you so much for taking the time to work on it!!
It would be nice to find this in the plugin section for easy download. Just saying! :D

Thanks for testing, and helping to finish the module. I'll finish the documentation ASAP, and upload it to the download section.

So it's finally finished. You'll find the plugin here https://www.zen-cart.com/downloads.php?do=file&id=2222

Design75:

So it's finally finished. You'll find the plugin here https://www.zen-cart.com/downloads.php?do=file&id=2222

This is a great plugin. Thanks very much for your work here, Design75! And mvstudio and other testers!

I found it quite easy to upload (with the merge required as indicated), easy to use and very helpful.

Thanks :smile:> GerriM:

This is a great plugin. Thanks very much for your work here, Design75! And mvstudio and other testers!

I found it quite easy to upload (with the merge required as indicated), easy to use and very helpful.

Does this plugin work with Super Orders ? I have installed it but the predefined comments don't get put in as a comment. Nothing happens.

Thanks

I have not tried that, but with some careful merging, I do not see why it wouldn't.

donw:

Does this plugin work with Super Orders ? I have installed it but the predefined comments don't get put in as a comment. Nothing happens.

Thanks

Design75 - sent you a PM.... need a response ASAP!

Carbonless:

Design75 - sent you a PM.... need a response ASAP!

It did work initially. I was using an old version of Safari. It worked using a much later version of Safari. However, it has stopped working again. I have installed a couple of other modules, which don't appear to have any code in common, so I may have to uninstall things to track down what the problem is.

Which Zen Cart, PHP version?
What is it exactly that is not working?
Are there any debug files created?
Without this information it is nearly impossible to help you.

donw:

It did work initially. I was using an old version of Safari. It worked using a much later version of Safari. However, it has stopped working again. I have installed a couple of other modules, which don't appear to have any code in common, so I may have to uninstall things to track down what the problem is.