Forums

This topic is locked

PhAkt, mySQL and UD4: no inserting of records

Posted 25 Apr 2002 22:05:58
1
has voted
25 Apr 2002 22:05:58 Ferry Spaan posted:
Hi All,

Please help me out here, because I am lost after several days of trying. First, let me tell you the configuration:
- Windows XP Pro
- Apache 1.3 installed (used installer)
- PHP 4.2 installed as a module(used installer and zip package)
- mySQL installed

All seem to work perfect. Apache works, I get phpInfo working and I can see records of my database with the correct users.

BUT, I cannot insert any record although I have granted privilegs for it. I can insert records when I use ASP. But when I turn over to Apache and PHP and start the Insert Record page (used PhAKT for it) I cannot insert it. The error log files gives no errors, the access log file says code 200, so it should be Ok.

I have no further error codes. But I think I have slipped one configuration file. But where to search: PHP.ini, my.ini or http.ini?
I do not know anymore since I do not get any error anymore.
I had in the beginning when I was using the wrong username, but after this fix ... no inserts of record. Starting IIS, starting my Insert record.asp file eh voila: insert record works.....

I am almost desperad where to search. I have tried several manuals, all the documentation files op PHP, Apache and MySQL and UDZone PhAkt tutorials. Is somebody able to point me the right direction? It cannot be much...

Thanks in advance for an almost crying developer.....

Regards, Ferry


Replies

Replied 25 Apr 2002 22:11:07
25 Apr 2002 22:11:07 Ferry Spaan replied:
In addition to previous post some of my PHPInfo results:

Hello everybody,

the function phpInfo shows following for mySQL:
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.39

Directive Local Value Master Value
mysql.allow_persistent
On On
mysql.default_host
localhost localhost
mysql.default_password
no value no value
mysql.default_port
no value no value
mysql.default_socket
no value no value
mysql.default_user
no value no value
mysql.max_links
Unlimited Unlimited
mysql.max_persistent
Unlimited Unlimited

Hope somebody can help me...

Replied 26 Apr 2002 10:17:45
26 Apr 2002 10:17:45 Tjerk Heringa replied:
<font face='Verdana'>Ferry,

this is similar to problems i had. First, remember to go to Windows Explorer and set the properties of the folder containing your db to websharing. Then, the second possibility to check is that you might have errors in your (update)query. If so, you will not get an errormessage in your browser. The database will just refuse to insert or update.

Veel succes,
Tjerk Heringa
</font id='Verdana'><font size=2></font id=size2>

Replied 26 Apr 2002 11:39:54
26 Apr 2002 11:39:54 Ferry Spaan replied:
Thank you Tjerk for your reply.

I tried imeddiatly to set the folder Data and the subdirectory that contains my db to sharing.

The insert record I use, is a direct result of the PhAkt option InsertRecordPHP. I set up a test table in the db to find out what is going wrong (two columns, both varchar)

Still, it is not working, but I keep on trying with this websharing.

If you have more ideas I would be pleased!

Groet, Ferry

Replied 27 Apr 2002 17:15:59
27 Apr 2002 17:15:59 anti trust replied:
Are you using MySQL in conjuction with MyODBC? If you are not, you must install MyODBC in order for windows to make a proper DSN connection and for UD to recognize any information about the MySQL database

Reply to this topic