Stories
Slash Boxes
Comments

Slash Open Source Project

Slashcode Log In

Log In

[ Create a new account ]

Journal of tf23 (175)

Monday December 23, 02

upgrading to R_2_3_0_62 slash

07:48 AM
Slash

Yesterday I spent many hours upgrading a slash site (one of 4) to the latest R tag in cvs.slashcode.com.
I think the whole process, beginning, to what we'll call the end, took about 5 or 6 hours.

The site is 99% functional.

I took notes throughout the whole process. I will post a story on one of my sites about it, w/ the notes, probably by next weekend. (It's the holidays, I've gotta get drunk and stuff myself numerous times over the course of the next few days).

So in the mean time, I thought I'd put up some of the errors I'd encountered.

I upgraded from CVS fry to CVS R_2_3_0_62.

I used the sql/mysql/upgrades file.

Some of the problems I had with it were (w/ the line from the upgrades file copied underneath the error):

ERROR 1062 at line 338: Duplicate entry '' for key 2
ALTER TABLE submissions ADD UNIQUE story_signature(signature);
ERROR 1091 at line 377: Can't DROP 'feature_story'. Check that column/key exists
#ALTER TABLE sections DROP feature_story;
ERROR 1062 at line 379: Duplicate entry '10' for key 1
INSERT INTO message_codes (code, type, seclev, modes) VALUES (10, 'Daily Site Stats', 100, 0);
ERROR 1062 at line 537: Duplicate entry 'displaycodes_sec--1' for key 2
INSERT INTO code_param (type, code, name) VALUES ('displaycodes_sectional', -1,'Don't Display');
INSERT INTO code_param (type, code, name) VALUES ('displaycodes_sectional', -1,'Don't Display');
ERROR 1062 at line 557: Duplicate entry 'cookiesecure' for key 1
INSERT INTO vars (name, value, description) VALUES ('cookiesecure','1','Set the secure flag in cookies if SSL is on?');
ERROR 1068 at line 683: Multiple primary key defined
ALTER TABLE modreasons CHANGE id id TINYINT UNSIGNED NOT NULL PRIMARY KEY;

after I did that, I had written up a few sql statements that needed to be run (basically change all the vars from sitename.org to test.sitename.org, etc), change writestatus, etc.

then i ran install-plugin to install the new plugins that I wanted on the site.

then I found out there were some scripts I needed to run: ./plugins/Zoo/rebuildPeople -u testbj ./utils/dst-update.plx testbj ./utils/colors-update.plx testbj

after all the time spent on this, I didn't give a crap how it looked. all I was going for last nite was functionality. I can fix cosmetics later.
So I blew away any customizations I had in the templats for the site's theme:

cd themes/slashcode/templates
template-tool -u testbj -s *
cd ../../../
cd plugins/Admin/templates/
template-tool -u testbj -s *
cd ../../..
cd plugins/PollBooth/templates/
template-tool -u testbj -s *
cd ../../..
cd plugins/Submit/templates/
template-tool -u testbj -s *
cd ../../..
cd plugins/Sections/templates/
template-tool -u testbj -s *
cd ../../..
cd plugins/Zoo/templates/
template-tool -u testbj -s *
cd ../../..
cd plugins/Journal/templates/
template-tool -u testbj -s *
cd ../../..
cd plugins/Hof/templates/
template-tool -u testbj -s *
cd ../../..
cd plugins/PubKey/templates/
template-tool -u testbj -s *
cd ../../..
cd plugins/Search/templates/
template-tool -u testbj -s *
cd ../../..
cd plugins/Messages/templates
template-tool -u testbj -s *
cd ../../..

then I imported my last postupgrade.sql file, and ran:

runtask -u testbj new_headfoot.pl
runtask -u testbj calstats.pl
runtask -u testbj freshenup.pl

the site works. one thing I haven't figured out:

Can't locate object method "getSectionTitle" via package "Slash::DB::MySQL"

and Failed template lookup on ';portald[misc];index[default]'

I grepped for the template. I did a find. I looked through cvs.slashcode.com.

No luck. Anyone have it?

Saturday January 26, 02

Plugins a comin

08:46 AM
Slash Plugins and Themes

I've got a classifieds plugin, and a re-worked Calendar plugin nearing completion. Recurring events and all. Anyone interested in betatesting/debuggin? :)

Friday January 04, 02

blah blah blah

07:55 AM
Slash

Obviously I don't use this much. But to all who'd ever click on it, possibly looking for more info about some of the slash-pluggins I'm working on, here's an update:

The plugin-development (calendar, photogallery) development has slowed to an all time crawl, almost non-existant. This is because we are frantically looking for a new house, we've gotta move.

I'm expecting this to be done by the end of Jan 2002.
Consequently, I'll hopefully have the time to finish both plugins then.

As always, goto http://lottadot.com/ for more info.

Saturday November 03, 01

credit card processing

08:23 AM
Bugs

Hey all, I'm starting to research credit card authentication companies. Do any of you have any recommendations, or prior experience with any vendors?

We are looking for information about this, in the hopes that we can a) add a slash compatable plugin that could do such transactions and b) offer it to the sites we are to host.