Error: Inserted data isn't exact or the database isn't liste

Discuss here how to configure hoteldruid and better use its features.

Moderator: marco

Post Reply
jwilmes
Posts: 55
Joined: Mon Feb 18, 2008 7:56 am
Location: Gulpen, The Netherlands

Error: Inserted data isn't exact or the database isn't liste

Post by jwilmes »

After installing on my web-site I tried to configure PHP-Residence. It gave me the error as mentioned above. There has been a topic about this issue earlier, but this was different because also an access issue. Here's my information:

- I created an empty database and username
- I used the prefix for my username (I don't get access error anymore)

It looks like I have to resolve a simple issue prior to using PHP-Residence.
whacker
Posts: 39
Joined: Fri Oct 27, 2006 2:32 pm

Post by whacker »

Hi
Have a look at this thread, If you haven't already
http://www.digitaldruid.net/php-residen ... .php?t=396

I'd,
Try another install, do you have Cpanel or something like that to check your files after install???
There may be a problem with the settings on the files....!!!
Walter
jwilmes
Posts: 55
Joined: Mon Feb 18, 2008 7:56 am
Location: Gulpen, The Netherlands

Post by jwilmes »

I looked into your article already. It does not solve my issue. I do have PHPAdmin and that shows nothing from the application (no tables are made what so ever). The username and password are OK though
whacker
Posts: 39
Joined: Fri Oct 27, 2006 2:32 pm

Post by whacker »

Hi
Ok then I guess the next question would be whether your website provider would support

REQUIRED SOFTWARE
-apache (>=1.3.26) or another web server that supports php
-php (>=3.0.18) with extension for postgresql, mysql or sqlite
-postgresql (>=7.4.7) or mysql (>=4.1.11) or sqlite
-a browser that supports forms with utf-8 encoding

I'm uploading all the file now for a new install, to see where the problem maybe..
This will help me remember what I did
Walter
whacker
Posts: 39
Joined: Fri Oct 27, 2006 2:32 pm

Post by whacker »

Hi
Did you create the database prior to installing the software??
If you create the database first, you should be able to verify that it's there using MYSQL...
I believe that after you install PHP Residence, you would have a window wher you enter the respective Table name, username and password which you used when you created the database!!
Walter

Create a new DATABASE in MySQL Databases eg.' onlinebook"
Create new USER eg ' tester ' with PASSWORD eg ' testing'
, select all privileges Add USER to DATABASE
jwilmes
Posts: 55
Joined: Mon Feb 18, 2008 7:56 am
Location: Gulpen, The Netherlands

Post by jwilmes »

Thank you for your reply Walter,

-I have asked PHP version from IP. No response yet. I think it's 2.11.4. Any way around this?
-All other advices I have done accordingly without succes.

Again thanks,

Jeroen
whacker
Posts: 39
Joined: Fri Oct 27, 2006 2:32 pm

Post by whacker »

Hi
Have a look at your Private Messages
As far as what to do with respect to PHP version, I don't no, Marco may be able to answer that!!!
I wonder if your problem is with creating the database and or access to it with PHP residence

In MYSQL
The first thing you would do is create the Database
Then you would create a Username, with a password, or you may already have some user names...
Next you Add Users to your Database ( the one you just crated , you will have to select it as well as the user), and select all Priveledges...
A note here you will find that the database has a prefix with an _ in front of the name..
It is important that you use the entire database name including that prefix as the database name when you configure PHP Residence initially...

Also, when you have this database created you can then go into PHPMYADMIN (I have Version 2.11.0) and see that it was created as well there you should also see the prefix again for that database
Walter
marco
Posts: 1332
Joined: Tue Jul 05, 2005 6:00 pm
Location: Roma, Italia

Post by marco »

Hello Jeroen,
I doubt you have a php version lower than 4. This issue seems related to server configuration and not to php-residence, so once checked that all the parameters are correct (not only username and password) you should ask for support to your hosting provider. If you're the one in charge of the server management try reading about database configuration in the php-residence README.

Marco
Problems installing, configuring, upgrading?
Try the easiest way to use HotelDruid:
https://www.digitaldruid.net/hosted/index.php
jwilmes
Posts: 55
Joined: Mon Feb 18, 2008 7:56 am
Location: Gulpen, The Netherlands

Post by jwilmes »

Hello marco and Walter,

It indeed was an access problem. I misinterpreted user rights. Now it's correct I seem te get further.

Thanks for your prompt help
Post Reply