Zen Cart Logo
Forums / All Other Contributions/Addons / Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Views: 84,097

Results 41 to 60 of 660
14 Dec 2010, 3:54 PM
#41
decostyle avatar

decostyle

Zen Follower

Join Date:
Mar 2008
Posts:
336
Plugin Contributions:
0

Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Just installed edit orders for 1.3.9 and am experiencing the same problem with the language file.

The admin page goes blank and this is the error:
[14-Dec-2010 09:47:18] PHP Warning: main(includes/languages/1.php) [<a href='function.main'>function.main</a>]: failed to open stream: No such file or directory in C:\xampp1\xampp\htdocs\store\admin\includes\init_includes\init_languages.php on line 36

[14-Dec-2010 09:47:18] PHP Fatal error: main() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/languages/1.php' (include_path='.;C:\xampp1\xampp\php\pear') in C:\xampp1\xampp\htdocs\store\admin\includes\init_includes\init_languages.php on line 36

I am running 1.3.9h, and only using english. When checking the init_languages.php file that file it is pertaining to is coded as '.php' with no 1.

Also since I didnot have super tracker, I just did not install the patch. I have TY tracker installed so have installed that part.

Any help or suggestion on how to fix this? Thanks

cyberian37:

Well it's working now, but what come up is an other problem in case I do try to change Status. Actually I can't, because otherwise come a page says this :

1054 Unknown column 'track_id1' in 'field list'
in:
[INSERT INTO orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments, track_id1, track_id2, track_id3, track_id4, track_id5) VALUES ('1', '3', now(), '1', '', '', '', '', '', '')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

> 
> In fact if I don' type anything into the Comments, the page just refresh and say that is updated, but it not. And if I try to type something into the Comments then become that Error.
> 
> Any idea ?
14 Dec 2010, 4:17 PM
#42
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

I can say that in all the testing that myself and fours others did on this version of Edit Orders BEFORE it was submitted, we CANNOT replicate this error AT ALL, and since cyberian37 never reported back how he resolved this same issue I am at a loss as to the cause.

I'm inclined to think that the problem may have something to so with another module you have installed.. Without seeing your store files I can only tell you what the error message means (a missing language file is being called that Zen Cart cannot find) I cannot say WHY this is happening at the moment.

So a few questions:
What version of Zen Cart are you running?
What other admin side mods do you have installed (please tell me WHICH versions of these mods as well)?
What tools/method did you use to upload the Edit Orders files?
Are you upgrading from a previous version of Edit Orders? If so which version??

Also I'm a little puzzled... You quoted cyberian37's post regarding the Ty Package Tracker error..

1054 Unknown column 'track_id1' in 'field list'

are you ALSO getting the same Ty Package Tracker fields missing error that he reported??

Also so there's no confusion it's SUPER ORDERS not Super Tracker..

Also since I didnot have super tracker, I just did not install the patch. I have TY tracker installed so have installed that part.

Decostyle:

Just installed edit orders for 1.3.9 and am experiencing the same problem with the language file.

The admin page goes blank and this is the error:
[14-Dec-2010 09:47:18] PHP Warning: main(includes/languages/1.php) [<a href='function.main'>function.main</a>]: failed to open stream: No such file or directory in C:\xampp1\xampp\htdocs\store\admin\includes\init_includes\init_languages.php on line 36

[14-Dec-2010 09:47:18] PHP Fatal error: main() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/languages/1.php' (include_path='.;C:\xampp1\xampp\php\pear') in C:\xampp1\xampp\htdocs\store\admin\includes\init_includes\init_languages.php on line 36

I am running 1.3.9h, and only using english. When checking the init_languages.php file that file it is pertaining to is coded as '.php' with no 1.

Also since I didnot have super tracker, I just did not install the patch. I have TY tracker installed so have installed that part.

Any help or suggestion on how to fix this? Thanks

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

14 Dec 2010, 8:34 PM
#43
decostyle avatar

decostyle

Zen Follower

Join Date:
Mar 2008
Posts:
336
Plugin Contributions:
0

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Hi thanks for the quick reply. Please see reply below:

What version of Zen Cart are you running? 1.3.9 H

What other admin side mods do you have installed (please tell me WHICH versions of these mods as well)?
TY Tracker for x2-3a
Quick Updates 2.04
Cross Sell 185
Module Manager rev15

What tools/method did you use to upload the Edit Orders files?
I'm currently testing on local host so just copy and past the files.

Are you upgrading from a previous version of Edit Orders? If so which version??
I had Edit Orders 2.03 then just over ride the files with the new ones.

Also I'm a little puzzled... You quoted cyberian37's post regarding the Ty Package Tracker error..
The problem is just on the language error, haven't even gone through the fields because right now my admin is blank.

I do not have SUPER Orders so have not installed the new files for this.

I have removed all the files since and re-installed again and went through checking step by step this is what I found:(all files have been renamed):

  1. Uploaded the files on Folder 1 Install Files.
  2. Checked and the admin is still running. no problem.
  3. Copy and pasted the Required core edits.
  4. Checked admin, was able to click on button EDIT and see the fields. Looks so much more improved! Yeah!
  5. Now I want to install the SQL...then the admin goes blank.
  6. Now cannot access the admin, even login is blank.

Went to cache debugging and I get the language file error.

Don't know what to make of it. Any suggestions?

14 Dec 2010, 9:27 PM
#44
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Now THAT is a useful answer!!!! Thank your for not only telling me what happened, but HOW you got there...

Okay.. Try this.. Can you un the uninstal SQL file.. Tell me what happens.. Also.. when you ran the install script HOW did you run it and did you get any errors/flags??

Decostyle:

Hi thanks for the quick reply. Please see reply below:

What version of Zen Cart are you running? 1.3.9 H

What other admin side mods do you have installed (please tell me WHICH versions of these mods as well)?
TY Tracker for x2-3a
Quick Updates 2.04
Cross Sell 185
Module Manager rev15

What tools/method did you use to upload the Edit Orders files?
I'm currently testing on local host so just copy and past the files.

Are you upgrading from a previous version of Edit Orders? If so which version??
I had Edit Orders 2.03 then just over ride the files with the new ones.

Also I'm a little puzzled... You quoted cyberian37's post regarding the Ty Package Tracker error..
The problem is just on the language error, haven't even gone through the fields because right now my admin is blank.

I do not have SUPER Orders so have not installed the new files for this.

I have removed all the files since and re-installed again and went through checking step by step this is what I found:(all files have been renamed):

  1. Uploaded the files on Folder 1 Install Files.
  2. Checked and the admin is still running. no problem.
  3. Copy and pasted the Required core edits.
  4. Checked admin, was able to click on button EDIT and see the fields. Looks so much more improved! Yeah!
  5. Now I want to install the SQL...then the admin goes blank.
  6. Now cannot access the admin, even login is blank.

Went to cache debugging and I get the language file error.

Don't know what to make of it. Any suggestions?
Posted via Mobile Device

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

15 Dec 2010, 1:58 PM
#45
decostyle avatar

decostyle

Zen Follower

Join Date:
Mar 2008
Posts:
336
Plugin Contributions:
0

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

In an attempt to try and isolate where the store goes haywire. I changed the sequence of installation as follows.

Firstly I took out all the edit orders files and uninstalled the SQL. Then...

  1. Installed SQL using the admin SQL function, copy and pasted then hit run.
  2. Checked admin, all working, no problem
  3. Added the TY Tracker file.
  4. Checked admin, no problem, clicked on Add tracking number, everything working ok.
  5. Added the overwrite core file.
  6. Checked admin, TY tracker still working, no problem viewing orders etal.
  7. Added the "Install Files" All the files.
  8. Now at first I can see the EDIT button and am able to view the order to edit. When I hit the "Add Products" everything goes haywire.

The page goes blank. Error about the language repeatedly comes up. Admin goes totally blank, can't even login. I have to remove all the files for edit order for the admin to go back to normal.

I'm wondering why of all errors it would be pointing to a language error?

The one other thing I need to try is to do it online in a test store to see whether it is the version of PHP that is affecting it. As I said this was being tested on local host which has a lower PHP version than the one required for 1.3.9H. Will report back soon.

Meanwhile hopefully someone else can help test it. This is a very useful module.

15 Dec 2010, 2:55 PM
#46
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

I did a little more research myself, and my next question to you was going to be regarding the version of PHP your local server is running.. Can you tell me what version of PHP you are running on your local server??

I can't locate it now, but I found a post DrByte had made elsewhere which discussed PHP versions and Zen Cart v1.3.9. I'll have to see if I can locate that post (I have to FIRST remember the search string I used to find it in the first place:laugh:) But I think that until you are testing/running this under the recommended PHP version for Zen Cart 1.3.9 we can't rule out server setup as a possible cause..

I wish that cyberian37's had shared HOW he finally resolved this same issue :( (it sounds like he eventually resolved the language errors).. It would have been imensely helpful to this process..

In any case I appreciate you sticking with this and continuing to provide DETAILED information.. It will help narrow things down a bit, and once we confirm what the issue is, I can update either the mod or the readme docs accordingly. (depending on the findings..)

Decostyle:

In an attempt to try and isolate where the store goes haywire. I changed the sequence of installation as follows.

Firstly I took out all the edit orders files and uninstalled the SQL. Then...

  1. Installed SQL using the admin SQL function, copy and pasted then hit run.
  2. Checked admin, all working, no problem
  3. Added the TY Tracker file.
  4. Checked admin, no problem, clicked on Add tracking number, everything working ok.
  5. Added the overwrite core file.
  6. Checked admin, TY tracker still working, no problem viewing orders etal.
  7. Added the "Install Files" All the files.
  8. Now at first I can see the EDIT button and am able to view the order to edit. When I hit the "Add Products" everything goes haywire.

The page goes blank. Error about the language repeatedly comes up. Admin goes totally blank, can't even login. I have to remove all the files for edit order for the admin to go back to normal.

I'm wondering why of all errors it would be pointing to a language error?

The one other thing I need to try is to do it online in a test store to see whether it is the version of PHP that is affecting it. As I said this was being tested on local host which has a lower PHP version than the one required for 1.3.9H. Will report back soon.

Meanwhile hopefully someone else can help test it. This is a very useful module.

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

15 Dec 2010, 3:13 PM
#47
decostyle avatar

decostyle

Zen Follower

Join Date:
Mar 2008
Posts:
336
Plugin Contributions:
0

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Hello, well it seems the PHP version is what is causing the instability.

My local host PHP version is PHP Version: 5.0.5 (Zend: 2.0.5).

The online host PHP version is PHP Version: 5.2.14 (Zend: 2.2.0)

When I installed the files online, went through the same sequence as above and everything worked just fine!

So there you have it. The current module as-is will probably only work in the higher PHP version.

Thanks!

15 Dec 2010, 3:16 PM
#48
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Whew!!! Thank you thank you thank you for sticking with this and providing such detailed feedback!!! (It's so much better than an "it's not working" post:laugh:)

I will update the readme docs for the next release accordingly!!!:clap:

Decostyle:

Hello, well it seems the PHP version is what is causing the instability.

My local host PHP version is PHP Version: 5.0.5 (Zend: 2.0.5).

The online host PHP version is PHP Version: 5.2.14 (Zend: 2.2.0)

When I installed the files online, went through the same sequence as above and everything worked just fine!

So there you have it. The current module as-is will probably only work in the higher PHP version.

Thanks!

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

15 Dec 2010, 11:22 PM
#49
sunflowertami avatar

sunflowertami

Zen Follower

Join Date:
Jun 2008
Posts:
267
Plugin Contributions:
0

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Hello,

I only sell downloadable files on my site. Does this work with downloadable products? The older version did...

Thanks for your help!

16 Dec 2010, 1:02 AM
#50
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Not sure what you mean by "old" version.. v1.53 is an OLD long outdated version of Edit Orders.. It advanced to the 2.x versions LONG ago..

As I indicated this is v2.04 with a few enhancments.. The changelog tells you the ENTIRE history of Edit Orders going all the way back to ver 1.2. At some point in it's evolution sturner stopped submitting his Edit Orders updates to the Zen Cart downloads.. So while it looks like 1.53 is the last update, there have in fact been MANY updates since v1.53 all which were only available if you got Edit Orders directly from sturner's site..

sunflowertami:

Hello,

I only sell downloadable files on my site. Does this work with downloadable products? The older version did...

Thanks for your help!
Posted via Mobile Device

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

18 Dec 2010, 8:09 PM
#51
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Version 3.02 is now available in the downloads.. If you upgrade PLEASE PLEASE PLEASE read the instructions.. We've made a few changes to better align with Ty Package Tracker v3.0 and Super Orders v3.0

Please check your host's PHP version before installing. This module will NOT work for hosting configurations using PHP versions older than 5.2.x

Change log for v3.02

  • Full integration of Ty Package Tracker files
  • MINOR edit to the orders.php file. Added "Details" icon and modified the "Edit" icon to correctly redirect to the Edit Orders page
  • Formatting fixes so that numeric entry fields right align (taxes, prices, additional total options, etc.)*
  • Modified the version numbering sequence. (No more "Rev" numbers)*
    *this was inadvertently left off the change log, but IS included in v3.02

Lastly I want to ask a SMALL favor.. When posting bugs/issues it's a WHOLE LOT more helpful to resolve if you post details. Just saying "it's broken" does not provide nearly enough information to help you resolve your issue. Please provide as MUCH information as possible including the version of Zen Cart you are running, the version of the module you are running, any other add-ons you may have also installed, and hosting/server information (PHP versions, mySQL versions, etc)

Because folks like Decostyle did this we were able to establish that this module will most likely not work if you have a version of PHP older than 5.2.x running..

Anyway.. carry on.. Enjoy the new version.. We've got more enhancements coming..:smile:

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

19 Dec 2010, 10:36 PM
#52
sanji avatar

sanji

Zen Follower

Join Date:
Jan 2005
Posts:
138
Plugin Contributions:
0

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

After installing the new 3.0.2 version of Edit Orders (I was previously using an old 1.0 version), together with the latest super orders 3 add-on, I too get some of the issues mentioned in this thread.

My ZC shop is using latest 1.3.9h version, with several add-ons, and works with French and English languages installed (English = 1, French = 2).

I have the following error message :

[19-Dec-2010 22:52:47] PHP Warning:  require(includes/languages/1.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in *****/web/adm/includes/init_includes/init_languages.php on line 35
[19-Dec-2010 22:52:47] PHP Warning:  require(includes/languages/1.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in *****/web/adm/includes/init_includes/init_languages.php on line 35
[19-Dec-2010 22:52:47] PHP Fatal error:  require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/languages/1.php' (include_path='.:/opt/php/lib/php') in *****/web/adm/includes/init_includes/init_languages.php on line 35

I also noticed that icons are not displayed on the edit_orders.php page, since the link of the icons is wrong, too, as it is for example :

includes/languages/2/images/buttons/button_back.gif

where "2" should be in fact "french".

Interestingly, part of the problem can be solved by removing lines 28-30 in edit_orders.php

//Begin Add language support
  //$language = (int)$_SESSION['languages_id'];
//End Add language support

Without those lines, the icons are now displayed properly, but I get another problem : If I click on "add products", I get the following error :

1054 Unknown column 'french' in 'on clause'
in:
[SELECT products_name, p.products_id, categories_name, ptc.categories_id FROM products p LEFT JOIN products_description pd ON (pd.products_id=p.products_id AND pd.language_id= french) LEFT JOIN products_to_categories ptc ON ptc.products_id=p.products_id LEFT JOIN categories_description cd ON (cd.categories_id=ptc.categories_id AND cd.language_id= french) ORDER BY categories_name]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Here, we should have in the code "2" instead of "french".

I believe that all those problems come from a bad handling of the language codes - it should be sometimes the name of the language, like "french", and sometimes the corresponding code letter, like "2" for me.

Hope this will help to advance toward a solution...

Thanks,

sanji

20 Dec 2010, 12:16 AM
#53
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

What version of PHP is your host running??

sanji:

After installing the new 3.0.2 version of Edit Orders (I was previously using an old 1.0 version), together with the latest super orders 3 add-on, I too get some of the issues mentioned in this thread.

My ZC shop is using latest 1.3.9h version, with several add-ons, and works with French and English languages installed (English = 1, French = 2).

I have the following error message :

[19-Dec-2010 22:52:47] PHP Warning: require(includes/languages/1.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in *****/web/adm/includes/init_includes/init_languages.php on line 35
[19-Dec-2010 22:52:47] PHP Warning: require(includes/languages/1.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in *****/web/adm/includes/init_includes/init_languages.php on line 35
[19-Dec-2010 22:52:47] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/languages/1.php' (include_path='.:/opt/php/lib/php') in *****/web/adm/includes/init_includes/init_languages.php on line 35

> 
> ```
includes/languages/2/images/buttons/button_back.gif
```where "2" should be in fact "french".
> 
> Interestingly, part of the problem can be solved by removing lines 28-30 in edit_orders.php
> 
> ```
//Begin Add language support
  //$language = (int)$_SESSION['languages_id'];
//End Add language support
```Without those lines, the icons are now displayed properly, but I get another problem : If I click on "add products", I get the following error :
> 
> ```
1054 Unknown column 'french' in 'on clause'
in:
[SELECT products_name, p.products_id, categories_name, ptc.categories_id FROM products p LEFT JOIN products_description pd ON (pd.products_id=p.products_id AND pd.language_id= french) LEFT JOIN products_to_categories ptc ON ptc.products_id=p.products_id LEFT JOIN categories_description cd ON (cd.categories_id=ptc.categories_id AND cd.language_id= french) ORDER BY categories_name]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
```Here, we should have in the code "2" instead of "french".
> 
> I believe that all those problems come from a bad handling of the language codes - it should be sometimes the name of the language, like "french", and sometimes the corresponding code letter, like "2" for me.
> 
> Hope this will help to advance toward a solution...
> 
> Thanks,
> 
> sanji

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

20 Dec 2010, 1:00 AM
#54
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

More information on your issue..

The missing language file error you are getting is as a result of 1 or BOTH of the following conditions..

  1. Your host is running a version of PHP prior to v5.2.x. (if you read the previous threads on this issue you would have seen that it's been confirmed that this module will generate the language error if you are running a version of PHP less than v5.2.x)
  2. As there are NO OTHER LANGUAGE files for Edit Orders other than english, the files needed for your default language (french) cannot be found which would ALSO lead to the error you are receiving.
    Your solution is to either update your version of PHP to the supported version and if you have not already done so, create the required french language files for Edit Orders.

The first solution was tested and confirmed by Decostyle. The second I just confirmed by changing my default language to "French" without having any language files in place. When I did this I got the same error you described. Once I created a set of french language files in my test store, the error disappeared.

Hope that helps.. If you do create a set of french translation files for this module I'll be happy to include it in the next update if you care to share it.. The french files I created for my testing will not be useful for those who speak the language. They were created by duplicating all my english files/folders and adding just a few french translations (using Google Translate) to some of the table headers so I could be sure that I was indeed seeing my french language files.

sanji:

After installing the new 3.0.2 version of Edit Orders (I was previously using an old 1.0 version), together with the latest super orders 3 add-on, I too get some of the issues mentioned in this thread.

My ZC shop is using latest 1.3.9h version, with several add-ons, and works with French and English languages installed (English = 1, French = 2).

I have the following error message :

[19-Dec-2010 22:52:47] PHP Warning: require(includes/languages/1.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in *****/web/adm/includes/init_includes/init_languages.php on line 35
[19-Dec-2010 22:52:47] PHP Warning: require(includes/languages/1.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in *****/web/adm/includes/init_includes/init_languages.php on line 35
[19-Dec-2010 22:52:47] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/languages/1.php' (include_path='.:/opt/php/lib/php') in *****/web/adm/includes/init_includes/init_languages.php on line 35

> 
> ```
includes/languages/2/images/buttons/button_back.gif
```where "2" should be in fact "french".
> 
> Interestingly, part of the problem can be solved by removing lines 28-30 in edit_orders.php
> 
> ```
//Begin Add language support
  //$language = (int)$_SESSION['languages_id'];
//End Add language support
```Without those lines, the icons are now displayed properly, but I get another problem : If I click on "add products", I get the following error :
> 
> ```
1054 Unknown column 'french' in 'on clause'
in:
[SELECT products_name, p.products_id, categories_name, ptc.categories_id FROM products p LEFT JOIN products_description pd ON (pd.products_id=p.products_id AND pd.language_id= french) LEFT JOIN products_to_categories ptc ON ptc.products_id=p.products_id LEFT JOIN categories_description cd ON (cd.categories_id=ptc.categories_id AND cd.language_id= french) ORDER BY categories_name]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
```Here, we should have in the code "2" instead of "french".
> 
> I believe that all those problems come from a bad handling of the language codes - it should be sometimes the name of the language, like "french", and sometimes the corresponding code letter, like "2" for me.
> 
> Hope this will help to advance toward a solution...
> 
> Thanks,
> 
> sanji

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

20 Dec 2010, 2:11 AM
#55
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Screenshot of my test store with French language set as my store default is attached.. As you can see Edit Orders works just fine once I had french language files in place.. (my translations come from Google Translate so I cannot attest to their complete accuracy..)

DivaVocals:

More information on your issue..

The missing language file error you are getting is as a result of 1 or BOTH of the following conditions..

  1. Your host is running a version of PHP prior to v5.2.x. (if you read the previous threads on this issue you would have seen that it's been confirmed that this module will generate the language error if you are running a version of PHP less than v5.2.x)
  1. As there are NO OTHER LANGUAGE files for Edit Orders other than english, the files needed for your default language (french) cannot be found which would ALSO lead to the error you are receiving.

Your solution is to either update your version of PHP to the supported version and if you have not already done so, create the required french language files for Edit Orders.

The first solution was tested and confirmed by Decostyle. The second I just confirmed by changing my default language to "French" without having any language files in place. When I did this I got the same error you described. Once I created a set of french language files in my test store, the error disappeared.

Hope that helps.. If you do create a set of french translation files for this module I'll be happy to include it in the next update if you care to share it.. The french files I created for my testing will not be useful for those who speak the language. They were created by duplicating all my english files/folders and adding just a few french translations (using Google Translate) to some of the table headers so I could be sure that I was indeed seeing my french language files.

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

20 Dec 2010, 10:47 AM
#56
sanji avatar

sanji

Zen Follower

Join Date:
Jan 2005
Posts:
138
Plugin Contributions:
0

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Thanks for the feedback.

I use PHP 5.2.14 (Zend : 2.2.0), so the version is up to date.

If I am correct, there is only 1 language file in admin, which is includes/languages/english/edit_orders.php. I have put exactly the same English file in my French admin folder as includes/languages/french/edit_orders.php

When I go to edit order, I will get all the texts of this add-on in English on my French site (which is obviously correct). see the screenshot attached. Again, no image is displayed, as the link of each image is incorrect.

When I click on the "Add product" button, I get a blank page and the usual error in the cache folder, see my previous post. The link to the "Add product" page is admin/edit_orders.php?oID=4334&action=add_prdct.

However, if I add the language in the URL, namely
admin/edit_orders.php?oID=4334&action=add_prdct**&language=french** or
admin/edit_orders.php?oID=4334&action=add_prdct**&language=english**,
then the page is working properly, although there is still no image working... See second attached screenshot.

Any hint on how to solve that?

20 Dec 2010, 1:23 PM
#57
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Choosing the spanish as my language, here is my Edit Order URL:
http://mydomain . com/my_admin/edit_orders.php?page=1&oID=10&action=edit

When I add a product here is the URL:
http://mydomain . com/my_admin/edit_orders.php?page=1&oID=10&action=add_prdct

Note my URLs are different form yours.. So you are going to have to provide more details on your setup etc.. (much in the same manner that Decostyle did) I cannot reproduce this error, and there is something different about your setup than mine to produce different results...

sanji:

Thanks for the feedback.

I use PHP 5.2.14 (Zend : 2.2.0), so the version is up to date.

If I am correct, there is only 1 language file in admin, which is includes/languages/english/edit_orders.php. I have put exactly the same English file in my French admin folder as includes/languages/french/edit_orders.php

When I go to edit order, I will get all the texts of this add-on in English on my French site (which is obviously correct). see the screenshot attached. Again, no image is displayed, as the link of each image is incorrect.

When I click on the "Add product" button, I get a blank page and the usual error in the cache folder, see my previous post. The link to the "Add product" page is admin/edit_orders.php?oID=4334&action=add_prdct.

However, if I add the language in the URL, namely
admin/edit_orders.php?oID=4334&action=add_prdct**&language=french** or
admin/edit_orders.php?oID=4334&action=add_prdct**&language=english**,
then the page is working properly, although there is still no image working... See second attached screenshot.

Any hint on how to solve that?

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

20 Dec 2010, 2:04 PM
#58
sanji avatar

sanji

Zen Follower

Join Date:
Jan 2005
Posts:
138
Plugin Contributions:
0

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Apart of the "page=1" part, it seems that the URL are quite similar to me, am I wrong?

I will try to check the function that generates the URLs, I am wondering if the problem if not coming from there. Obviously, it is something related to a language function... Perhaps a variable behaving strangely.

My exact URL is http://www.sogival.com/~xxx/my_admin/edit_orders.php?page=1&oID=4330&action=add_prdct so it seems quite identical to want is expected. Again, adding simply &language=french at the end makes it works.

Even more strange to me, is that once I get the blank page, the whole admin side will stop working even if I just try to go to the main page. The only way to access the site is to add &language=french or &language=english to any URL, like the one of the main page index.php?language=english. This problem happens when I am trying to edit an order both in English or in French, so it is not dependant to one of the language specifically...

Will try to research more...

20 Dec 2010, 3:19 PM
#59
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

deleted

Wrong images... will repost..

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

20 Dec 2010, 3:35 PM
#60
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

Thanks.. Honestly I am baffled. This error doesn't happen to everyone. It only seems to affect certain store setups.

One person's issue was related to the version of PHP they were running on their local server.. The other person who reported this issue NEVER reported back how they resolved it (it would have been nice if they shared what they did shrug)

Most others are not having this issue at all.. NONE of the folks testing this prior to the release reported EVER getting this issue.. (There were four of us running this version of Edit Orders and testing it.. We tested this for several months before it was ever submitted)

So the ONLY way to get to the bottom of it is for you to provide as much information as possible about your store/hosting setup.. (Because I am nearly sure that the heart of the issue lies in something unique to your store/host setup..)

> sanji:

Apart of the "page=1" part, it seems that the URL are quite similar to me, am I wrong?

I will try to check the function that generates the URLs, I am wondering if the problem if not coming from there. Obviously, it is something related to a language function... Perhaps a variable behaving strangely.

My exact URL is http://www.sogival.com/~xxx/my_admin/edit_orders.php?page=1&oID=4330&action=add_prdct so it seems quite identical to want is expected. Again, adding simply &language=french at the end makes it works.

Even more strange to me, is that once I get the blank page, the whole admin side will stop working even if I just try to go to the main page. The only way to access the site is to add &language=french or &language=english to any URL, like the one of the main page index.php?language=english. This problem happens when I am trying to edit an order both in English or in French, so it is not dependant to one of the language specifically...

Will try to research more...

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.