Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
bugthefixer
Forum Contributor
Posts: 118 Joined: Mon Mar 22, 2004 2:35 am
Post
by bugthefixer » Mon Jun 28, 2004 7:18 am
when i like to write through web to a databse table it says its read only.
my database is on linux server and i have cecked it provides full rights .
error it gives is
1036: Table 'train' is read only
patrikG
DevNet Master
Posts: 4235 Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK
Post
by patrikG » Mon Jun 28, 2004 7:22 am
moved to "databases"
1. what database are you using?
2. have you checked you're access-rights?
bugthefixer
Forum Contributor
Posts: 118 Joined: Mon Mar 22, 2004 2:35 am
Post
by bugthefixer » Mon Jun 28, 2004 8:12 am
I m using mysql..
and i have checked it very well..it works fine through phpmyadmin but not through my php code..
patrikG
DevNet Master
Posts: 4235 Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK
Post
by patrikG » Mon Jun 28, 2004 9:29 am
can phpmyadmin write to the table?
bugthefixer
Forum Contributor
Posts: 118 Joined: Mon Mar 22, 2004 2:35 am
Post
by bugthefixer » Tue Jun 29, 2004 1:41 am
yes it works fine with phpMyAdmin...my code works fine on one server but it gives error on one server...but when i update it using java servlets then it doesnt give any error..
hairyjim
Forum Contributor
Posts: 219 Joined: Wed Nov 13, 2002 9:04 am
Location: Warwickshire, UK
Post
by hairyjim » Tue Jun 29, 2004 2:53 am
works fine on one server but it gives error on one server
Are you using one server for serving your MySQL db and a different one that serves your web pages?
bugthefixer
Forum Contributor
Posts: 118 Joined: Mon Mar 22, 2004 2:35 am
Post
by bugthefixer » Tue Jun 29, 2004 5:58 am
sorry i mean wors fine on one server but not on other actually i tried it on different servers..