Welcome to Geeklog, Anonymous Thursday, May 02 2024 @ 07:12 pm EDT

Comments for Database Schema

Database Schema | 7 comments | Create New Account

The following comments are owned by whomever posted them. This site is not responsible for what they say.

Database Schema

Authored by: Anonymous (Anonymous User) on Wednesday, April 24 2002 @ 11:22 am EDT

Is this final release\'s datbase schema any different from the RC1 schema? I\'ve loaded data into the RC1 version already and I\'d rather not have to redo it all.

Thanks!

Database Schema

Authored by: Matty on Wednesday, April 24 2002 @ 12:30 pm EDT

There is no upgrade file for 1.3.5rc1 -->1.3.5, as it was only a release candidate. Anyways, try this, I believe it\'s the only change...

Backup your db, then execute the following

ALTER TABLE stories ADD show_topic_icon tinyint(1) unsigned NOT NULL default \'1\' AFTER featured;

---
Matty

Database Schema

Authored by: Dirk on Wednesday, April 24 2002 @ 12:54 pm EDT

You also need to do this:

ALTER TABLE users ADD photo varchar(128) DEFAULT NULL

bye, Dirk

Database Schema

Authored by: amckay on Saturday, April 27 2002 @ 06:41 am EDT

Is there a complete list of all DB changes from 1.3.4 to 1.3.5. I know it\'s my own fault because I was warned against pulling GL out of CVS, but I\'m running a version which is between 1.3.4 and 1.3.5, pre RC1. It has a few DB changes so the regular upgrade won\'t work.

Database Schema

Authored by: amckay on Saturday, April 27 2002 @ 08:22 am EDT

Success! I dug out the upgrade scripts and was able to use them to do a manual upgrade of my DB, and now 1.3.5 is running on my 2 main sites!

A while back you had given me a quick and easy hack for not displaying any right blocks, but I forget where it was. You can see on http://bodensatz.quay.net/ that I do not use any right blocks, but now after the upgrade there is just a big blank space down the right side.

I\'ll search around to find the hack (I think I saved details somewhere) but maybe in the meantime if you check in you can post details as well.

Thanks again for 1.3.5 -- lots of great stuff!

fixed it

Authored by: amckay on Sunday, April 28 2002 @ 01:02 pm EDT

OK, I fixed it. I found the hack you had given me before but it does not work anymore since the code was cleaned up and the hard-coded HTML was removed.

I then looked in the layout/<my-template-name>/rightblocks.thtml and found the culprit.

I\'m now humming along just fine!
thanks,
-Alan

Warning: Javascript required to enable functionality

Post a Comment

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks