View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: No Primary Key
PostPosted: Mon Jul 04, 2005 10:23 am 
Offline
Joined: Sun Jun 12, 2005 11:24 am
Posts: 32
Location: East Lansing, MI
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?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 04, 2005 12:49 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 04, 2005 1:27 pm 
Offline
Joined: Sun Jun 12, 2005 11:24 am
Posts: 32
Location: East Lansing, MI
Thank you very much, worked like a charm. :D


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 13 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu