Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
edd (Guest)
edd (Guest)
Hi,
 
PLEASE HELP!!!
I am just at the install.php page, I enter the following details:
 
Database Type: MySQL
Hostname: localhost
Database name: test
Username: root
Password: *****
 
Persistent Connection: Unchecked.
Create DB: Unchecked.
Populate DB: Checked.
Test Data: Checked.
 
I hit "Next" and I keep getting the message "PHP functions for mysql are not defined. Please check your database settings in your configuration file - php.ini."
 
I've got the following installed on Windows:
PHP 5.2.2,
MySQL 5.0.41,
Apache 2.2,
Zend Optimizer 3.2.8
 
My c:/php/php.ini file contains the line: extension=php_mysqli.dll
 
Also - I've successfully tested php files connecting and retrieving MySQL data prior to this ViArt installation attempt.
 
Within the php.ini file I've got settings for [MySQLi] but not [MySQL] as recommended for MySQL 5.
 
Are there other settings within php.ini that need updating for ViArt 3.1 installation???
 
Please help!!!!
 
Eugene (Guest)
Eugene (Guest)
Hi,
 
ViArt Shop uses common MySQL client library (php_mysql.dll), not improved one (php_mysqli.dll).
So, please uncomment the following line in the php.ini file (just remove semicolon before it):
 
extension=php_mysql.dll
 
WBR,
ViArt Support team
 
edd (Guest)
edd (Guest)
Thanks Eugene! That worked!
 
Although I'm not sure I understand why...
 
If the following 2 lines are uncommented in the php.ini:
 
extension=php_mysql.dll
extension=php_mysqli.dll
 
Doesn't that mean that ViArt will want to use all the settings under [MySQL] instead of all the settings under [MySQLi] in the php.ini??
 
theo38
theo38
I have both
 
extension=php_mysql.dll
extension=php_mysqli.dll
 
uncommented in my php.ini but I still get this error.
 
Do you have any suggestions?
 
Eugene (Guest)
Eugene (Guest)
Hi Theo,
 
Please check that parameter "extension_dir" is set correctly in your php.ini file.
 
WBR,
ViArt Support Team
 
I have both
 
extension=php_mysql.dll
extension=php_mysqli.dll
 
uncommented in my php.ini but I still get this error.
 
Do you have any suggestions?
 
brad (Guest)
brad (Guest)
Hi Theo,
 
I've tried both the ideas above and i'm still getting the same error!? The same as above: When i search the php.ini file for "extension_dir" it can't find any listing for it in the file....
 
My local settings are:
 
Database Type: MySQL
Hostname: localhost
Database name: test
Username: root
Password: *****
 
Persistent Connection: Unchecked.
Create DB: Unchecked.
Populate DB: Checked.
Test Data: Checked.
 
Help! Thanks,
 
Brad.
 
 
Please check that parameter "extension_dir" is set correctly in your php.ini file.
 
WBR,
ViArt Support Team
 
I have both
 
extension=php_mysql.dll
extension=php_mysqli.dll
 
uncommented in my php.ini but I still get this error.
 
Do you have any suggestions?
 
brad (Guest)
brad (Guest)
Hi again,
 
Scratch the post above (from me)
 
I just search the php.ini files again and the extension_dir is pointing to extension_dir ="C:\Program Files\PHP\ext" which is the correct directory for the files but i still get this error.... my settings are
 
Database Type: MySQL
Hostname: localhost
Database name: test
Username: root
Password: *****
 
Persistent Connection: Unchecked.
Create DB: Unchecked.
Populate DB: Checked.
Test Data: Checked.
 
Help! Thanks,
 
Brad.
 
 
Please check that parameter "extension_dir" is set correctly in your php.ini file.
 
WBR,
ViArt Support Team
 
I have both
 
extension=php_mysql.dll
extension=php_mysqli.dll
 
uncommented in my php.ini but I still get this error.
 
Do you have any suggestions?
 
brad (Guest)
brad (Guest)
Ok i finally fixed this problem!
 
The information Eugene left solves half the problem:
 
You need to go into the folder you installed you php program in and edit the php.ini file using notepad. and remove the semi colon before the "extension=php_mysql.dll"
 
You then need to check the "extension_dir" entry (which shoul be somewhere near by in the php.ini file.
 
make sure this extension_dir points to where the file "php_mysql.dll" file lives on your hard drive (in my case it was extension_dir="C:\Program Files\PHP\ext")
 
This is where problem 2 begins: if you go to your php folder and it does not have a subfolder "\ext" then the problem is... when php was installing itself it didn't install the "extensions" files on you hard drive. If this is the case goto the add remove programs section in the control panel and click the "change" option to reconfiger php. add the extensions option to php and follow the installation prompts.
 
If this still doesn't work then it's a problem with mysql.
(ps. if you EVER reinstall mysql make sure you once you unistalled it you go to the command prompt start/run and type cmd and at the prompt type "sc delete mysql" that will remove the program from the registry and save you ALOT of headaches!)
 
Hope this made sense and helps!
 
Kumar (Guest)
Kumar (Guest)
HI,
 
I have php version 5.2.4.4. I have problem with mysql connection. In php.ini, i did not find "extension=php_mysql.dll" & "xtension=php_mysql.dll ".
 
Please help me solve this problem.
 
Mkumar
 
teste (Guest)
teste (Guest)
HI,
 
I trying install the viart shop free and I'm stuck with problem
 
PHP functions for mysql are not defined. Please check your database settings in your configuration file - php.ini.
 
Can you please help me,
 
 
Best regards,
 
Paulo
 
kidmarmite (Guest)
kidmarmite (Guest)
I'm having the same problem. Same error. Extension dir is correct and the mysql extension is uncommented. MySQL is set up correctly.
 
Not sure where to look next.
 
- kidmarmite
 
Praveen kumar (Guest)
Praveen kumar (Guest)
I have same problem but after getting your advice its solved.
Thanks
 
Praveen kumar (Guest)
Praveen kumar (Guest)
1. Error:-mysql_connect() invalid function error
Resolved:- By Updating php.ini file
just make somechanges and its running sucsesfully.
(1) First make change in
extension=php_mysql.dll(remove ; from this line)in php.ini.
(2) Second Make full path off ext
extension_dir ="C:\Program Files\IndigoPerl\php\ext" rather than ext.
 
2. Error:- to run Viart_cms(Zend installation error)
Download Zend and Viart_CMS from viart.com nad zend.com
 
and installed for zend php.ini path set to c:/indigoperl/php
 
then its work. correctly.
 
Thanks