[SOLVED] error 1054 inserting new ezpage
Here's the solution to eliminate 1054 error in inserting new multilanguage ezpages.
In .../CUSTOM_ADMIN/ezpages.php you have to modify following block:
PHP Code:
$sql_data_array = array('pages_title' => $pages_title,
'page_open_new_window' => $page_open_new_window,
'page_is_ssl' => $page_is_ssl,
'alt_url' => $alt_url,
'alt_url_external' => $alt_url_external,
'status_header' => $status_header,
'status_sidebox' => $status_sidebox,
'status_footer' => $status_footer,
'status_toc' => $status_toc,
'header_sort_order' => $pages_header_sort_order,
'sidebox_sort_order' => $pages_sidebox_sort_order,
'footer_sort_order' => $pages_footer_sort_order,
'toc_sort_order' => $pages_toc_sort_order,
'toc_chapter' => $toc_chapter,
'pages_html_text' => $pages_html_text);
to:
PHP Code:
$sql_data_array = array('page_open_new_window' => $page_open_new_window,
'page_is_ssl' => $page_is_ssl,
'alt_url' => $alt_url,
'alt_url_external' => $alt_url_external,
'status_header' => $status_header,
'status_sidebox' => $status_sidebox,
'status_footer' => $status_footer,
'status_toc' => $status_toc,
'header_sort_order' => $pages_header_sort_order,
'sidebox_sort_order' => $pages_sidebox_sort_order,
'footer_sort_order' => $pages_footer_sort_order,
'toc_sort_order' => $pages_toc_sort_order,
'toc_chapter' => $toc_chapter);
Re: Multi-Language Support for EZ-Pages
installed this module , i just noticed php warning in my debug log file regarding ezpages.php . here it is
PHP Warning: trim() expects parameter 1 to be string, array given in C:\wamp\www\test\admin\ezpages.php on line 140
PHP Warning: addslashes() expects parameter 1 to be string, array given in C:\wamp\www\test\admin\includes\functions\database.php on line 65
I really need to fix this , as this is the only warning i do get on entire site .
warning happens when i add or update ezpages ..
Re: Multi-Language Support for EZ-Pages
Quote:
Originally Posted by
pasi
ZenCart team rejected my submission (because of an error I had made). I accidentaly copied wrong version to the dir I zipped and submitted... I have corrected it now, but will hone some little details in it before re-submitting.
Just wait for it :)
Hey pasi,
I know you said just wait for it, but it has been almost two months now, so is there any news on the resubmission? :cool:
Re: Multi-Language Support for EZ-Pages
Quote:
Originally Posted by
tony_sar
installed this module , i just noticed php warning in my debug log file regarding ezpages.php . here it is
PHP Warning: trim() expects parameter 1 to be string, array given in C:\wamp\www\test\admin\ezpages.php on line 140
PHP Warning: addslashes() expects parameter 1 to be string, array given in C:\wamp\www\test\admin\includes\functions\database.php on line 65
I really need to fix this , as this is the only warning i do get on entire site .
warning happens when i add or update ezpages ..
sorry for bumping this , but need to know if anyone knows how to fix this warning
thanks
Re: Multi-Language Support for EZ-Pages
Hi everybody,
I have install 1.3.9h version and successfully install Greek language. When I try to install the module I get this error:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9
in:
[CREATE TABLE IF NOT EXISTS ezpages_content ( pc_id int(11) NOT NULL auto_increment, pages_id int(11) NOT NULL default '0', languages_id int(11) NOT NULL default '1', pages_title varchar(64) NOT NULL default '', pages_html_text text, PRIMARY KEY (pc_id), KEY idx_ezpages_content (pages_id,languages_id) ) TYPE=MyISAM]
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.
Any ideas for what it could be wrong???:blink:
Re: Multi-Language Support for EZ-Pages
Quote:
Originally Posted by
dimkostis
Hi everybody,
I have install 1.3.9h version and successfully install Greek language. When I try to install the module I get this error:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9
in:
[CREATE TABLE IF NOT EXISTS ezpages_content ( pc_id int(11) NOT NULL auto_increment, pages_id int(11) NOT NULL default '0', languages_id int(11) NOT NULL default '1', pages_title varchar(64) NOT NULL default '', pages_html_text text, PRIMARY KEY (pc_id), KEY idx_ezpages_content (pages_id,languages_id) ) TYPE=MyISAM]
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.
Any ideas for what it could be wrong???:blink:
open ezpages_install.php located in your admin folder.
around line 45 change
TYPE=MyISAM
to
ENGINE=MyISAM
Re: Multi-Language Support for EZ-Pages
Quote:
Originally Posted by
tony_sar
open ezpages_install.php located in your admin folder.
around line 45 change
TYPE=MyISAM
to
ENGINE=MyISAM
That works just fine!!!!! thank you!!!!! :D :)
Re: Multi-Language Support for EZ-Pages
Quote:
Originally Posted by
Design75
Hey pasi,
I know you said just wait for it, but it has been almost two months now, so is there any news on the resubmission? :cool:
Same question here, actually maybe this is one of the most used plugins on zen cart but nobody has updated it to 1.5 version. Even I think Ez Pages must be multilanguage by default. I hope this come within next zen cart update. PLEASE make update soon, We really need it...
Re: Multi-Language Support for EZ-Pages
Dear Sir
I need to make multi language zen website, I did that fine, but I need also the ez pages to have multi languages
I am using zencart 1.5 .
Is the multilanguage_ezpages_1.3.0.5v2.02 compatible with it?
thanks In advance
Re: Multi-Language Support for EZ-Pages
Quote:
Originally Posted by
islam
Dear Sir
I need to make multi language zen website, I did that fine, but I need also the ez pages to have multi languages
I am using zencart 1.5 .
Is the multilanguage_ezpages_1.3.0.5v2.02 compatible with it?
thanks In advance
Dear All,
please can any one help me and ask my question --urgently--
I tried the available multilanguage_ezpages add-on, but I didn't work.
is there a version for zencart1.5?
thanks
