| fida  Entries: 9 |  Problem in logging in | Hello!
I just downloaded the sofware and I'm trying to log in by the "super username" and password but it is not logging in.
Also I'm getting these 2 errors:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\wamp\www\DYNPG_421_2010-11-23\header.php on line 37
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\DYNPG_421_2010-11-23\header.php on line 42
Thanks for your help! | | | | | |
| 21.12.2010 13:47 |  CITE | ANSWER |
| Daniel Schliebner  Entries: 353 | Hi!
It seems that you did not install the cms in the right way. The Wiki gives an introduction into the installation process. Probably the database tables could not be created correctly. Please make sure that the database which you specified inside the installation routines exists. Are there any MySQL tables installed? Do you passed the whole installation process as decribed in the wiki (above)? | Mit freundlichen Grüßen
ds-develop
Daniel Schliebner
Webmaster & Programmierer
http://www.ds-develop.de
Bietzkestraße 18A
10315 Berlin
GERMANY
Tel.: +49 30 33980300 | | | |
| 21.12.2010 14:11 | CITE | ANSWER |
| fida Entries: 9 | Hi Daniel!
I unistalled DynPG & installed it again but it I still got the same error (of course using Wiki as my guideline).
I think the issue may be because I'm using Windows where it does not let you change the file or folder permissions. (I didn't change the permission of the cms folder, and the 2 other files).
Do you know any way I can get around this problem.
Thank you so much for your help! | | | | | |
| 22.12.2010 08:47 | CITE | ANSWER |
| Daniel Schliebner Entries: 353 | Hi!
I am developing in a WAMP environment as well, so this cannot be the reason. In fact, the folder permission do not play a role in this environment.
Indeed, the problem that can be derived from the error messages you've posted, indicates that there is a problem with the connection to your local MySQL database and/or that the installation of the database tables did not worked.
Please look, if the following is true:
- in your dynpg root folder exists the file config.php
- the data inside the config.php is correct, that is the constants MYSQL_SERVER, MYSQL_USER, MYSQL_PASSWORD and MYSQL_DATABASE contain correct data.
- inside the database MYSQL_DATABASE which you have specified during the installation process, there exists the dynpg database tables such as "dynpg_cms_user" etc. (maybe you forget to create the specified mysql database before starting the installation?)
However, there has to be a problem with the communication between dynpg and your database and something seems to be faulty.
| Mit freundlichen Grüßen
ds-develop
Daniel Schliebner
Webmaster & Programmierer
http://www.ds-develop.de
Bietzkestraße 18A
10315 Berlin
GERMANY
Tel.: +49 30 33980300 | | | |
| 22.12.2010 09:51 | CITE | ANSWER |
| Daniel Schliebner Entries: 353 | | There just came another question in my mind: can you please post, which versions of PHP and MySQL do you use? | Mit freundlichen Grüßen
ds-develop
Daniel Schliebner
Webmaster & Programmierer
http://www.ds-develop.de
Bietzkestraße 18A
10315 Berlin
GERMANY
Tel.: +49 30 33980300 | | | |
| 22.12.2010 09:55 | CITE | ANSWER |
| fida Entries: 9 | Hi Daniel!
I'm going to delete the database and uninstall and do it all over again and of course checking what you told me regarding the communication betweem dynpg & the database.
I'm using PHP 5.2.6 and MySQL 5.0.51 b
Thanks! | | | | | |
| 22.12.2010 10:12 | CITE | ANSWER |
| fida Entries: 9 | Hello!
I made sure that in the config.php all the information is correct & I created a database called dynpg but for some reason it is empty even after the installation.
I'm very sorry for bothering you with my problem.
Thank you so much for your time! | | | | | |
| 22.12.2010 10:21 | CITE | ANSWER |
| Daniel Schliebner Entries: 353 | Hi!
Hmm, okay and in the finaly screen of the installation, where you get the message "dynpg installed sucessfully" (see
here ) are no error messages?
I expect, that you are using PHPMyAdmin as DB admin software as well? Then try to go into the database "dynpg" you have just created and execute the sql file "/install/sqlbin/dynpg.sql" handish. Are there any errors? Are all tables created?
Here is another more detailed (but german) description of the installation. Maybe something is still not clear. If you are not familiar with the german language you might take this link: google translated version | Mit freundlichen Grüßen
ds-develop
Daniel Schliebner
Webmaster & Programmierer
http://www.ds-develop.de
Bietzkestraße 18A
10315 Berlin
GERMANY
Tel.: +49 30 33980300 | | | |
| 22.12.2010 10:35 | CITE | ANSWER |
| Chris  Entries: 379 | Hi,
In fact it looks like a conection problem between php and your mysql server or dynpg tables.
Did you recheck if a conection to your mysql server, with the user credentials entered during the dynpg installation process and held within config.php of your cms root installation path, is possible?
Enter them in phpMyAdmin and you will see if a conection is possible or not.
So before you're going to install DynPG, the Database which is going to be used must exist and aswell a mysql user with enough rights to create tables etc. in the choosen DB.
So try to recheck the MySQL userrights on that Database aswell.
greetings
chris.w. | *************************************
Christoph Würsch
Urbanización Aranjuez
Asturianas No° 23
Asuncion / Paraguay
-------------------------------------
Tel: +595 (0)21 332 984
-------------------------------------
http://www.chriswuersch.com
************************************* | | | |
| 22.12.2010 13:25 | CITE | ANSWER |
| Daniel Schliebner Entries: 353 | Hej,
of course, the connection to the database has to be successful, since otherwise he would instantly get a message
"Cannot connect to MySQL Server. Please contact your administrator."
or
"No connection to database X. Please contact your administrator."
which is not the case here. Consequently, this cannot be an issue here. But in fact, it further can exist a problem with the rights of the specified MySQL user, which Chris stated correctly within the last post. | Mit freundlichen Grüßen
ds-develop
Daniel Schliebner
Webmaster & Programmierer
http://www.ds-develop.de
Bietzkestraße 18A
10315 Berlin
GERMANY
Tel.: +49 30 33980300 | | | |
| 22.12.2010 17:35 | CITE | ANSWER |
| fida Entries: 9 | Hi Chris!
Hi Daniel!
Thank you guys for your help!
I did the following: I created a database in phpmyadmin, and I created a user and created him all the privileges to the database.
Then I installed dynpg.
After I finished intalling dynpg I went to the database to check if it got populated it didn't.
However, the config.php has the correct information.
I really appreciate your time and effort!
Thank you so very much!! | | | | | |
| 23.12.2010 08:57 | CITE | ANSWER |
| Daniel Schliebner Entries: 353 | Hi!
Did you furthermore tried to execute the sql file stated a few posts above (dynpg.sql) manually inside your phpmyadmin in order to check, wheather the created mysql user is allowed to create tables? | Mit freundlichen Grüßen
ds-develop
Daniel Schliebner
Webmaster & Programmierer
http://www.ds-develop.de
Bietzkestraße 18A
10315 Berlin
GERMANY
Tel.: +49 30 33980300 | | | |
| 23.12.2010 09:44 | CITE | ANSWER |
| fida Entries: 9 | Hello!
Daniel, I did what you said...I ran the dynpg.sql inside the phpmyadmin.
I had No errors!!
but I'm getting that I can't log in...it is not taking the username & password :S
Thanks ever so much!! | | | | | |
| 23.12.2010 10:28 | CITE | ANSWER |
| Daniel Schliebner Entries: 353 | Hi!
Ah, ok, so when you executed the sql file manually, there where no errors and there exist several tables inside the database? If so, you might execute the sql inside the attachment and as a consequence you should be able to login with "admin" and "password". | Mit freundlichen Grüßen
ds-develop
Daniel Schliebner
Webmaster & Programmierer
http://www.ds-develop.de
Bietzkestraße 18A
10315 Berlin
GERMANY
Tel.: +49 30 33980300 | | Attachments | | 1 | Attachment (Filetype: zip, Filesize: 3 Kb) | | |
| 23.12.2010 10:49 | CITE | ANSWER |
| fida Entries: 9 | Hi again!
Thank you Daniel it FINALLY worked but I'm getting an error in the language. I was able to finally log in but I'm getting this notice:
Notice: Undefined index: lang_postLogin_title in C:\wamp\www\DYNPG_421_2010-11-23\_lastModified.php on line 352
There is a table where the headers are in german but the links on the left are in English.
Daniel I can't thank you enough! | | | | | |
| 23.12.2010 11:18 | CITE | ANSWER |
| Daniel Schliebner Entries: 353 | Hi,
well but we still don't know, why the usual installation process didn't worked but of course you can now work with the CMS.
However, the message you get after the login is a bug, which will be fixed with version 4.2.2. Until this update is released you can apply the bugfix inside the attachment. Simply copy the files and folders from the ZIP into the dynpg root such that the corresponding files are replaced by their new versions inside the ZIP. | Mit freundlichen Grüßen
ds-develop
Daniel Schliebner
Webmaster & Programmierer
http://www.ds-develop.de
Bietzkestraße 18A
10315 Berlin
GERMANY
Tel.: +49 30 33980300 | | Attachments | | 1 | Attachment (Filetype: zip, Filesize: 61 Kb) | | |
| 23.12.2010 11:49 | CITE | ANSWER |
| fida Entries: 9 | Dear Daniel,
Thank you so much for all your help!
I really would like to thank you and the support team for your help.
You guys are great!!!
Regards,
Fida | | | | | |
| 23.12.2010 14:46 | CITE | ANSWER |
| Daniel Schliebner Entries: 353 | Hej Fida,
absolutely no problem. Best regards and a merry christmas! | Mit freundlichen Grüßen
ds-develop
Daniel Schliebner
Webmaster & Programmierer
http://www.ds-develop.de
Bietzkestraße 18A
10315 Berlin
GERMANY
Tel.: +49 30 33980300 | | | |
| 23.12.2010 14:50 | CITE | ANSWER |
