I have a foreach function which groups an array of products, into seperate arrays depending on the 'dsid': $products_array = array(); $products_query = tep_db_query("select products_id, products_name, drop_ship_id from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$orders['orders_id'] .…
I am using Plesk 11 on a Centos6 server and have created an openemm database but when I try to import the openemm-2013.sql file into it I am receiving the following message: QL query: GRANT DELETE , INSERT , UPDATE…
The Scenario I keep trying to log into my Plesk MySql database called psa using the following command: mysql psa -uadmin -ppassword*! ( This command of course assumes my password is password*! ). But I keep getting the following error:…
i'm using codeigniter for create a web site. and i need to take result from mysql table as this object(mysqli_result)#2 (5) { ["current_field"]=> int(0) ["field_count"]=> int(4) ["lengths"]=> NULL ["num_rows"]=> int(12) ["type"]=> int(0) } but always i got as a result…
1st of all I'd like to underline the fact that same script does work on another server and never throws the error. So it's not something inside the script, but something in the server config / mysql connections. So there…
I am working on a project that uses OSCommerce with MySQL and I'm confused as to when I should use tep_db_input() or tep_db_prepare_input(). I'd assume I should use tep_db_input() around any strings that are being inserted/updated, but then when should…
In order to create a new database i use Plesk Panel. I am also using mysql workbench to administer my database instances. The problem is that when i connect to a database in my server (via workbench) using its unique…
Actually, I would like to switch the engine of my tables. There are in InnoDB and I want to set them to MyISAM because of this ALTER TABLE `xxx_db`.`yyy` ADD FULLTEXT `ft_modele` ( `anno_modele` ) Error : Documentation #1214 -…
I was browsing mysql-slow-logs to check for potentiall optimization and I've noticed weird schema in them ( see below ): SELECT password, type FROM accounts AS a JOIN sys_users AS s ON (a.id = s.account_id) WHERE s.login='**DICTIONARY_USER_NAME_HERE**' AND (SELECT count(*)…
I have osCommerce installed with a website that has 140k products and product_description table size is about 300MB. Page load tooks 15 second to 20 second, I cut the table to 100MB for testing purpose and now it seem it…