LinHES Forums
http://forum.linhes.org/

No Primary Key
http://forum.linhes.org/viewtopic.php?f=6&t=5179
Page 1 of 1

Author:  DrewCS [ Mon Jul 04, 2005 10:23 am ]
Post subject:  No Primary Key

I accidentally switched my theme to Minimalist-wide, and now I can't change it back. I did some searching and found out that the setting for the theme is stored in the MySQL database. Using Webmin I found the value I need to change, but it won't allow me to change it.

Code:
Data in this table cannot be edited because it has no primary key.


Does anyone know where I can go from here?

Author:  tjc [ Mon Jul 04, 2005 12:49 pm ]
Post subject: 

You'll need to use the raw SQL interface (click on the "Execute SQL" button) and do something like this:
Code:
delete from settings
where value = 'Theme'
and hostname = 'YOURHOSTNAMEHERE'

Followed by:
Code:
insert into settings
values ('Theme' , 'Iulius', 'YOURHOSTNAMEHERE')

Then restart the frontend somehow. For example, running
Code:
/etc/init.d/gdm restart
as root.

Author:  DrewCS [ Mon Jul 04, 2005 1:27 pm ]
Post subject: 

Thank you very much, worked like a charm. :D

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/