I got a problem regarding creating database for phpay.
My situation:
- Win2K Pro UK
- MySql 3.23(latest recommended release)
- PHP 4.30
- Apache webserver 2.0
- PhPay 2.02
I got the site working with php/sql working. But when i use http://localhost/phpayv2/admin/admain.php and fill here the required parms... I got the following message: 'Datenbankparamter ndern:'.
I am new in php and mysql. Please advice!
Thanks.
Henk.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Please check first if your PHP-Installation works with register_globals=On (php.ini). I'm not really sure all parts work with option 'Off', i.e. file uploads.
Greetings,
Andreas.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok.... thx... this takes me further.... Now I see that i am not authorized for connection to mysql.
For now, the phpay - scripts are open for everyone...
Mysql is running... in mysql.ini the user and pass and host are set to an authorised user. What am i still doing wrong?
Thx in advance for you help.
Henk.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Because your first steps of installation went wrong, now a file config_db.inc.php exists, but no values are in it :-(
Ether you write the right values by hand with e text editor in it or you delete them; after delete go again to phapy/admin/index.php to enter data again (register_globals are On?)
Note: there are two files in admin- and shop folder.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok... i created the database. Also created all the tables in the database. Inserted all the entries which i all took from 'create_db.inc.php'.
I also checked and created the files 'config_db.inc.php'/'config.inc.php'.
Admin part is working fne now. No problems at all.
However... There must have been something wrong with the user table. I got an error while creating it.
I created that one manually. Primary keys/indexes etc... all good.
Than.... i tried to login into the shop.... I filled in new user info and got the following error:
Fatal error: Call to undefined function: getmxrr() in C:\Webserver\webshop\phpay\publicuupd.inc.php on line 18
Where is that function (getmxrr) located?
I have no clue at the moment.
Thanks in advance...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi there, I am curios on how you were finally able to create the tables.
I have made all the sama changes to me setup up as descibed here but still no luck
still get that boring comment .
Best regards
Haugur
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Nice work done to get all SQL-queries from create_db*php. In admin/doc-directory is a *.sql -file, which contains only SQL-Queries. You can use this file together with phpMyAdmin ...
PHP-function getmxrr() is not implemented in Windows-version of PHP. You can disable its use in admin-area Configuration.
Greetings,
Andreas.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
getmxrr() is not implemented in Windows-version of PHP.
To switch off this 'error' set in configuration 'Check mailaddress' to 'simple' and not 'with DNS'. Then this function isn't used.
You need at least one user in your user table:
ID=2
firstname=public
name=user
password=public
(But seems you have it)
Greetings,
Andreas.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I got a problem regarding creating database for phpay.
My situation:
- Win2K Pro UK
- MySql 3.23(latest recommended release)
- PHP 4.30
- Apache webserver 2.0
- PhPay 2.02
I got the site working with php/sql working. But when i use http://localhost/phpayv2/admin/admain.php and fill here the required parms... I got the following message: 'Datenbankparamter ndern:'.
I am new in php and mysql. Please advice!
Thanks.
Henk.
Please check first if your PHP-Installation works with register_globals=On (php.ini). I'm not really sure all parts work with option 'Off', i.e. file uploads.
Greetings,
Andreas.
Ahhhhh, i found a setting ' display_errors'
When i changed this to on... I found a lot of errors in phpay. Probably i installed it wrong..
All undeclared variablen (db_function and title_handlers.)
What am i doing wrong?
Thanks for your help.
Dont set error_reporting to E_ALL. Take: E_ALL & ~E_NOTICE !
Ok.... thx... this takes me further.... Now I see that i am not authorized for connection to mysql.
For now, the phpay - scripts are open for everyone...
Mysql is running... in mysql.ini the user and pass and host are set to an authorised user. What am i still doing wrong?
Thx in advance for you help.
Henk.
Because your first steps of installation went wrong, now a file config_db.inc.php exists, but no values are in it :-(
Ether you write the right values by hand with e text editor in it or you delete them; after delete go again to phapy/admin/index.php to enter data again (register_globals are On?)
Note: there are two files in admin- and shop folder.
Register globals is set to on.
config_db.inc.php i removed from the folder.
error_reporting is at E_ALL & ~E_NOTICE !
I entered the data in there. But no file is created.
I still got the same message as before: 'Datenbankparamter ndern:'.
Sorry for being such a newbie but I really appreceate your help.
thx,
Henk
Ok... i created the database. Also created all the tables in the database. Inserted all the entries which i all took from 'create_db.inc.php'.
I also checked and created the files 'config_db.inc.php'/'config.inc.php'.
Admin part is working fne now. No problems at all.
However... There must have been something wrong with the user table. I got an error while creating it.
I created that one manually. Primary keys/indexes etc... all good.
Than.... i tried to login into the shop.... I filled in new user info and got the following error:
Fatal error: Call to undefined function: getmxrr() in C:\Webserver\webshop\phpay\publicuupd.inc.php on line 18
Where is that function (getmxrr) located?
I have no clue at the moment.
Thanks in advance...
Hi there, I am curios on how you were finally able to create the tables.
I have made all the sama changes to me setup up as descibed here but still no luck
still get that boring comment .
Best regards
Haugur
Nice work done to get all SQL-queries from create_db*php. In admin/doc-directory is a *.sql -file, which contains only SQL-Queries. You can use this file together with phpMyAdmin ...
PHP-function getmxrr() is not implemented in Windows-version of PHP. You can disable its use in admin-area Configuration.
Greetings,
Andreas.
Ahhh... I found it... Its PEAR.
Next step is... how do i set it right in the versions i have? It should be a part of PHP 430. ok.. where.. how to activate it?
Thanks in advance.
getmxrr() is not implemented in Windows-version of PHP.
To switch off this 'error' set in configuration 'Check mailaddress' to 'simple' and not 'with DNS'. Then this function isn't used.
You need at least one user in your user table:
ID=2
firstname=public
name=user
password=public
(But seems you have it)
Greetings,
Andreas.