update record: table is read only

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
davek
Forum Newbie
Posts: 12
Joined: Sat Mar 15, 2003 5:21 pm
Location: chicago

update record: table is read only

Post by davek »

I did this Record Store Tutorial at Macromedia

I got to the end of it where I can use the adminedit.php to update a record, but when i click the UPDATE RECORD i get this: Table 'album' is read only.

Is there a way for me to change the tables to read and write?
Is this a privelege issue? I am using the root user with all priveleges.
Thanks
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

MySQL version? Operating System and version?

Mac
davek
Forum Newbie
Posts: 12
Joined: Sat Mar 15, 2003 5:21 pm
Location: chicago

Post by davek »

Mac OS 10.2.4
MySQL 3.23.55
PHP 4.3.0
I am using the root user with a password.
davek
Forum Newbie
Posts: 12
Joined: Sat Mar 15, 2003 5:21 pm
Location: chicago

Post by davek »

I've got it working now. I built a new database using phpMyAdmin and having a feeling I know where I went wrong.

The tutorial says
From the RecordStorePHPStart folder copy the database, called "recordstorePHP" and paste it in your MySQL Data folder. For me that is c:\MySQL\data. You do not need to keep the copy of your database in the RecordStorePHPStart folder once you have it in your MySQL data folder. If you have winmysqladmin loaded, you can see the recordstorePHP database in your database tab.
If you don't have winmysqladmin installed, you may want to get it at <http://www.mysql.com/downloads/download ... inadmn.zip>. There are other great MySQL GUIs available as well and most can be found at
<http://www.mysql.com/downloads/download.php>
What I did on my 10.2.4 Mac was search for the mysql folder and changed the owner and permissions in it's info panel then copied the "recordstorePHP" to the data folder inside the mysql folder. Then I changed the ownership back to mysql and locked it. This isn't the way to move a database into mysql is it? Any links for info on the proper method for importing a db on a Mac 10.2.4?

At first I thought this was the problem:
I also have this at the bottom of my phpMyAdmin
Error
The additional Features for working with linked Tables have been deactivated. To find out why click here
I setup the phpmyadmin db and made the change to the config.inc.php, but the message is still on the bottom of the page.

Thanks
Post Reply