problem with accessing database file

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bugthefixer
Forum Contributor
Posts: 118
Joined: Mon Mar 22, 2004 2:35 am

problem with accessing database file

Post by bugthefixer »

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
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

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 »

I m using mysql..
and i have checked it very well..it works fine through phpmyadmin but not through my php code..
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

can phpmyadmin write to the table?
bugthefixer
Forum Contributor
Posts: 118
Joined: Mon Mar 22, 2004 2:35 am

Post by bugthefixer »

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 »

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 »

sorry i mean wors fine on one server but not on other actually i tried it on different servers..
Post Reply