The secure CMS.

Welcome to Geeklog, Anonymous Thursday, April 18 2024 @ 09:06 pm EDT

Geeklog Forums

Change the Dates on All Stories

 New Topic  Post Reply
 07/08/05 04:30pm (Read 2,142 times)  
Status: offline

Sonnyb

Forum User
Junior
Registered: 05/21/05
Posts: 22
Location:Tampa, FL
Does anyone know of a simple way to change the date of all stories? Maybe an SQL command? I don't know enough about SQL to be comfortable messing with it without some guidance from the geeklog gods Smile

Thanks
 Quote
 07/08/05 07:29pm  
Status: offline

matthewcox

Forum User
Junior
Registered: 12/11/03
Posts: 31
Location:Asheville, North Carolina
ArrowIf you have phpmyadmin, select your database and select the SQL tab

in the query field us this command(changing the date and time to what you want)
Text Formatted Code

UPDATE `stories` set `date` = "2003-12-02 19:13:00"


 


ArrowIf you have shell access run these to commands(you'll need your geeklog database password)
mysql -p -u yoursusername geeklogdatabasename
UPDATE `stories` set `date` = "2003-12-02 19:13:00";

see example session below

Text Formatted Code

$ mysql -p -u yoursusername geeklogdatabasename
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 1346329 to server version: 4.0.24-standard

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> UPDATE `stories` set `date` = "2003-12-02 19:13:00";

 


enjoy!

-Matthew Cox

 Quote
 07/08/05 10:08pm  
Status: offline

Sonnyb

Forum User
Junior
Registered: 05/21/05
Posts: 22
Location:Tampa, FL
Thanks for the quick reply, worked like a charm.
 Quote
 07/09/05 01:55am  
Status: offline

matthewcox

Forum User
Junior
Registered: 12/11/03
Posts: 31
Location:Asheville, North Carolina
Glad to hear. Very Happy

It does make me curious though, what purpose or effect does this achieve?

Always interested in new creative ways of using geeklog...

-Matthew Cox
 Quote
 New Topic  Post Reply
All times are EDT. The time is now 09:06 pm.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content