Guest Posted April 23, 2014 Share Posted April 23, 2014 May I suggest algozone.com. Great prices and customer service. I use them. Strange I have one from them. Just last week, lots of errors in template and several tickets sent. Ticket system not working and they don't answer any emails. Link to comment Share on other sites More sharing options...
azpro Posted September 8, 2014 Share Posted September 8, 2014 I am in the process of updating from 2.3.3.2 to 2.3.3.3/2.3.3.4 and especially the upgrade to UTF-8 and database conversion to UTF-8 gives me some problems. What I did with relevant changes: - upload the new/updated functions/database.php - 2.3.3.4 (both in catalog and admin) - RELEVANT function tep_db_connect() with mysqli_set_charset($$link, 'utf8'); - changed includes/languages/includes/english.php - RELEVANT : setlocale(LC_ALL, array('en_US.UTF-8', 'en_US.UTF8', 'enu_usa')); define('CHARSET', 'utf-8'); - changed includes/languages/includes/dutch.php - RELEVANT: setlocale(LC_ALL, array('nl_NL.UTF-8, nl_NL.UTF8, nld_nld'));; define('CHARSET', 'utf-8'); These changes offcourse give a lot of "unknown / badly showed" characters on both admin and catalog. We were running up till now with ISO_8859-1 both english and dutch. So I gave it a try with converting a test table with admin/databasetables.php FROM latin1_swedish_ci to utf8_unicode_ci.This seemed to give the expected result (EG characters like é converted to éé) ... But in an other field (same test table off-course) the text was "deleted" after é. Both columns have Type mediumtext and the new Collation utf8_unicode_ci set by the update. So I am puzzled here over the inconsistency. Any thgoughts? Link to comment Share on other sites More sharing options...
♥mommaroodles Posted September 8, 2014 Share Posted September 8, 2014 Strange I have one from them. Just last week, lots of errors in template and several tickets sent. Ticket system not working and they don't answer any emails. they havent been responding to any tickets now for sometime nor do they respond to comments left on their facebook page. The last template I bought from them was very disappointing to say the least. I used them quite often over the years and I wont be using them any longer. "The doorstep to the temple of wisdom is a knowledge of our own ignorance." Link to comment Share on other sites More sharing options...
♥mommaroodles Posted September 12, 2014 Share Posted September 12, 2014 another thing I've noticed is the inconsistency of the indexes in the oscommerce.sql file. it would appear that the naming convention for the indexes is "idx_table_name_column_name" and all in lowercase, however there are some which are just the idx_column_name and then some that are in uppercase. take this for example: DROP TABLE IF EXISTS action_recorder; CREATE TABLE action_recorder ( id int NOT NULL auto_increment, module varchar(255) NOT NULL, user_id int, user_name varchar(255), identifier varchar(255) NOT NULL, success char(1), date_added datetime NOT NULL, PRIMARY KEY (id), KEY idx_action_recorder_module (module), KEY idx_action_recorder_user_id (user_id), KEY idx_action_recorder_identifier (identifier), KEY idx_action_recorder_date_added (date_added) ) CHARACTER SET utf8 COLLATE utf8_unicode_ci; in the above we can see idx_tablename_columnname below we have idx_columname DROP TABLE IF EXISTS banners; CREATE TABLE banners ( banners_id int NOT NULL auto_increment, banners_title varchar(64) NOT NULL, banners_url varchar(255) NOT NULL, banners_image varchar(64) NOT NULL, banners_group varchar(10) NOT NULL, banners_html_text text, expires_impressions int(7) DEFAULT '0', expires_date datetime DEFAULT NULL, date_scheduled datetime DEFAULT NULL, date_added datetime NOT NULL, date_status_change datetime DEFAULT NULL, status int(1) DEFAULT '1' NOT NULL, PRIMARY KEY (banners_id), KEY idx_banners_group (banners_group) ) CHARACTER SET utf8 COLLATE utf8_unicode_ci; and even in uppercase - a few tables DROP TABLE IF EXISTS countries; CREATE TABLE countries ( countries_id int NOT NULL auto_increment, countries_name varchar(255) NOT NULL, countries_iso_code_2 char(2) NOT NULL, countries_iso_code_3 char(3) NOT NULL, address_format_id int NOT NULL, PRIMARY KEY (countries_id), KEY IDX_COUNTRIES_NAME (countries_name) ) CHARACTER SET utf8 COLLATE utf8_unicode_ci; so its very apparent that there doesnt seem to be a set standard and it's def not following any form of 'best practice' "The doorstep to the temple of wisdom is a knowledge of our own ignorance." Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.