from UBBThreads to vbulletin

flint · July 12th, 2005, 05:51 PM

I just switched from UBBT to vb3 and need some help updating the photopost tables. I´m able to write some import scripts myself, I just need some hints regarding certain db fields, as of photopost 4.5!

Most of it seems easy, my biggest concern are the usergroups.
The current usergroups had been imported from threads, of course they are outdated now.

Could I simply manually change the usergroups to current id´s from vb3, then rerun all category configuration in the backend?
What´s bothering me is db table "categories", with four field referencing the old groups:
- ugnoview
- ugnoupload
- ugnopost
- ugnoanno

Or should I just empty those fields after updating the usergroups manually, and then check the rest in the backend, reassign correct permissions before reopening?

Thanks in advance!

flint · July 12th, 2005, 05:52 PM

The rest seems easy to me, I´ll just list it, in case someone has to go the same route:

No update needed:
- admingroups
- admlog
- ecards (empty)
- exif (empty)
- ipcache (userid always "0")
- iponline (empty)
- sort
- sortmemb
- users (empty)

Need update in fields "userid" and "username"
- comments

Need update in "userid" only:
- userid
- laston
- notify
- I´ll just have to update userid - easy!

need updating in "userid" and "user"
- photos

settings
of course I´ll have to change the registration system from threads to vbulletin

Chuck S · July 12th, 2005, 05:56 PM

exacty and usergroups just do this

in phpmyadmin delete every group except threads admin groupid1. Just change that to 6 and then relogin into photopost and refresh usergroups to import the vb3 usergroups into it

categories table you need to just reset usergroup permissions and can use the update children to do children or issue a mass query via phpmyadmin whichever you want

flint · July 13th, 2005, 07:26 PM

I updated all tables specified, checked the frontend. Everything looked fine, except for missing thumbnails.
So I went straight to the backend, checked the configuration, all fine, and ran "Check for and create missing thumbnails."

And it gave me a lot like this:
"Checking photo #10821: image /var/www/poisonfree/community/gallery/data/500/816894564041_m.gif not found, removing from database... done."

Before: over 1GB of photos
After: 24 MB

I was close to a heartattack until I figured out that /data still holds 1.5 GB of data, but what happened?!?

Pooohaaaa - Imagine me, one day before a short holiday trip to the Czech Republic, 2:00 AM, getting a lot of "removing from database" messages ....

yes I do have current sql backups, but I thought this thing was actually wiping nearly all images from the harddrive, until I checked the data folder.

Chuck S · July 13th, 2005, 07:36 PM

Well your thumbnails have nothing to do with switching

I would say your upgrade. Replace an sql backup of the photos table up and run upgrade.php from your last version to the latest. Make sure on the upgrade 485-486 upgrade that the data folder is correct path in photopost config and 777 and you only run the step 3 ONCE.

You should be fine after that on thumbs

flint · August 27th, 2005, 08:10 PM

Quote:

Originally Posted by omegatron

Well your thumbnails have nothing to do with switching

I would say your upgrade. Replace an sql backup of the photos table up and run upgrade.php from your last version to the latest. Make sure on the upgrade 485-486 upgrade that the data folder is correct path in photopost config and 777 and you only run the step 3 ONCE.

You should be fine after that on thumbs

ok, now I found the time to do some testing:

I modified the usergroups as recommended, changed some settings to fit vb3 - logged in successfully and imported the usergroups.
frontend, backend, everything looked fine.

then I uploaded all 5.1 files and ran upgrade.php, all I got was a blank page containing nothing but <html><body></body></html>, all other pages as well, from frontend to backend

what do think went wrong?

I tried again with backups, but I can´t figure out what went wrong ...

Chuck S · August 28th, 2005, 11:21 AM

Have you ran all upgrades?? That would be where I would check

flint · August 28th, 2005, 11:50 AM

Quote:

Originally Posted by omegatron

Have you ran all upgrades?? That would be where I would check

yes I have run all upgrades, but some with errors:

the database sayi 4.5, so that´s where I started:

Preparing to update 4.5 database...

Performing MySQL command: ALTER TABLE categories ADD theme VARCHAR(32) NOT NULL; ... Error: Duplicate column name 'theme'
Performing MySQL command: ALTER TABLE categories ADD catdepth varchar(6) DEFAULT NULL; ... Error: Duplicate column name 'catdepth'
Performing MySQL command: ALTER TABLE categories ADD watermark varchar(255) NOT NULL default ''; ... Error: Duplicate column name 'watermark'
Performing MySQL command: ALTER TABLE iponline ADD item VARCHAR(16) NOT NULL default ''; ... Error: Duplicate column name 'item'
Performing MySQL command: ALTER TABLE usergroups ADD useralbums int(3) NOT NULL default '0'; ... Error: Duplicate column name 'useralbums'
Performing MySQL command: REPLACE INTO settings VALUES (134, 'Use Anti-leeching code?', 'right-click', 'Use Right-Click Disable Script', 'no', 18, 6); ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (135, 'Display number of viewers on categories?', 'displayonline', 'Adds a query to main index, but shows numbers of viewers per category', 'yes', 60, 2); ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme--
Copyright 2005 All Enthusiast, Inc.',300,'0'); ... Successful!
Performing MySQL command: DROP TABLE stylesheet; ... Error: Unknown table 'stylesheet'
Upgrade complete! You should continue to next step

-----------------

Preparing to update 4.6 database...

Performing MySQL command: ALTER TABLE photos ADD storecat INT(12) DEFAULT '0' NOT NULL AFTER `cat` ... Error: Duplicate column name 'storecat'
Performing MySQL command: ALTER TABLE photos ADD storeid INT(12) DEFAULT '0' NOT NULL AFTER `storecat` ... Error: Duplicate column name 'storeid'
Performing MySQL command: REPLACE INTO settings VALUES (136, 'Allow users to choose additional categories during upload?', 'optcats', '', 'no', 19, 6) ... Successful!

Upgrade complete! You should continue to next step

----------------

Preparing to update 4.6.7 database...

Performing MySQL command: REPLACE INTO settings VALUES (137, 'Enable slideshows?', 'slideshow', '', 'yes', 19, 6) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (138, 'Enable next and previous photo previews?', 'nextbox', '', 'yes', 20, 6) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (139, 'How many days after an eCard has been read do you want to keep it?', 'cardage', '', '7', 99, 5) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (140, 'Expire eCards after how many days (even if not read)?', 'cardexpire', '', '90', 100, 5) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (141, 'Acceptable multimedia file types?', 'acceptmm', 'Seperate file types by a comma and include the . (example: .mpg,.wma,.asf,.mp3)', '.mpeg,.mpg,.avi,.asf,.wmv,.mov', 89, 3) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (142, 'Acceptable image file types?', 'acceptimg', 'Seperate file types by a comma and include the . (example: .jpg,.gif,.png)', '.jpg,.jpeg,.png,.gif', 89, 3) ... Successful!
Performing MySQL command: ALTER TABLE usergroups ADD reqmod INT(3) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'reqmod'
Performing MySQL command: ALTER TABLE ecards ADD returnr INT(15) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'returnr'
Performing MySQL command: ALTER TABLE notify ADD type INT(2) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'type'
Performing MySQL command: ALTER TABLE ecards ADD readdate INT(15) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'readdate'
Performing MySQL command: DELETE FROM settings WHERE id = 22 ... Successful!
Performing MySQL command: DELETE FROM settings WHERE id = 57 ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (143,'Select a border for your thumbnails','thumbborder','Choose from the available borders for your thumbnails','thumbnail',62,2); ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (84,'PhotoPost Version','pversion','','4.7',53,0) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme--
Copyright 2005 All Enthusiast, Inc.',300,'0') ... Successful!

Upgrade complete! You should continue to next step

-----------

Preparing to reorganize admin options...

INSERT INTO admingroups VALUES (7,'Comments Options') failed with error: Duplicate entry '7' for key 1
INSERT INTO admingroups VALUES (8,'Registration Options') failed with error: Duplicate entry '8' for key 1
INSERT INTO admingroups VALUES (9,'Layout Options') failed with error: Duplicate entry '9' for key 1
INSERT INTO admingroups VALUES (10,'Watermark Options') failed with error: Duplicate entry '10' for key 1
ALTER TABLE comments ADD ipaddress VARCHAR(32) failed with error: Duplicate column name 'ipaddress'
ALTER TABLE photos ADD ipaddress VARCHAR(32) failed with error: Duplicate column name 'ipaddress'
INSERT INTO admingroups VALUES (11, 'Sidebar Settings') failed with error: Duplicate entry '11' for key 1
INSERT INTO settings VALUES (144, 'Sidebar Placement?', 'sidebar', 'Set this to off for no sidebar or left or right depending on your tastes.', 'off', 1, 11) failed with error: Duplicate entry '144' for key 1
INSERT INTO settings VALUES (145, 'Sidebar Width', 'sidebar_width', ' Choose the width for your sidebar', '20%', 4, 11) failed with error: Duplicate entry '145' for key 1
INSERT INTO settings VALUES (146, 'Under Category PAL?', 'undercat', ' Display Recent Comments and Who\'s Online Pals', 'no', 5, 11) failed with error: Duplicate entry '146' for key 1
INSERT INTO settings VALUES (147, 'Statistics PAL?', 'statspal', ' Display Statistics Pal?', 'yes', 6, 11) failed with error: Duplicate entry '147' for key 1
INSERT INTO settings VALUES (148, 'Top Posters PAL?', 'topposterspal', ' Display Top Posters Pal?', 'no', 7, 11) failed with error: Duplicate entry '148' for key 1
INSERT INTO settings VALUES (149, 'Random Image PAL?', 'randompal', ' Display Random Image?', 'yes', 8, 11) failed with error: Duplicate entry '149' for key 1
INSERT INTO settings VALUES (150, 'Highest Ratings PAL?', 'ratingspal', ' Display Highest Ratings?', 'no', 9, 11) failed with error: Duplicate entry '150' for key 1
INSERT INTO settings VALUES (151, 'Show Sidebar on Index Page?', 'sidebar_index', '', 'no', 2, 11) failed with error: Duplicate entry '151' for key 1
INSERT INTO settings VALUES (152, 'Show Sidebar Globally?', 'sidebar_global', 'Showsidebar on showphoto,showmembers and showgallery pages?', 'no', 3, 11); failed with error: Duplicate entry '152' for key 1
INSERT INTO settings VALUES (153, 'Default theme setting (UBBThreads users only)', 'threads', 'Threads Users: We need to know what the site default theme setting is.', 'infopop', 18, 1) failed with error: Duplicate entry '153' for key 1
INSERT INTO settings VALUES (154, 'Show signatures?', 'showsigs', 'When available, display signatures?', 'yes', 27, 5) failed with error: Duplicate entry '154' for key 1
INSERT INTO settings VALUES (155, 'Show Avatars?', 'showavatar', 'When available, show avatars?', 'yes', 28, 5) failed with error: Duplicate entry '155' for key 1
INSERT INTO settings VALUES (156, 'Show Category Avatars?', 'indexavatars', 'Do you want to display the Index Avatars?', 'yes', 9, 3) failed with error: Duplicate entry '156' for key 1
INSERT INTO settings VALUES (157, 'Display Custom PAL #1', 'custom1pal', ' If you modified the custom1pal.tmpl and want to include it set to yes', 'no', 11, 11) failed with error: Duplicate entry '157' for key 1
INSERT INTO settings VALUES (158, 'Display Custom PAL #2', 'custom2pal', ' If you modified the custom2pal.tmpl and want to include it set to yes', 'no', 12, 11) failed with error: Duplicate entry '158' for key 1
INSERT INTO settings VALUES (159, 'Display Custom PAL #3', 'custom3pal', ' If you modified the custom3pal.tmpl and want to include it set to yes', 'no', 13, 11) failed with error: Duplicate entry '159' for key 1
INSERT INTO settings VALUES (160, 'Number of Top Posters to display', 'numtoppal', '', '5', 14, 11) failed with error: Duplicate entry '160' for key 1
INSERT INTO settings VALUES (161, 'Number of Last Comments to display', 'numcompal', '', '5', 15, 11) failed with error: Duplicate entry '161' for key 1
INSERT INTO settings VALUES (162, 'Number of Most Popular Photos to display', 'mostpoppal', '', '5', 16, 11) failed with error: Duplicate entry '162' for key 1
INSERT INTO settings VALUES (163, 'Use Integrated forum stylesheets?', 'forumstyle', 'If you use a forum like vB3 or Threads and want to use the intergated stylesheet option, choose Yes', 'no', 19, 1) failed with error: Duplicate entry '163' for key 1
INSERT INTO settings VALUES (164, 'Use Whos Online PAL?', 'onlinepal', '', 'yes', 10, 11) failed with error: Duplicate entry '164' for key 1
ALTER TABLE usergroups ADD canassign INT(3) DEFAULT '0' NOT NULL failed with error: Duplicate column name 'canassign'
ALTER TABLE categories ADD sortorder INT(2) DEFAULT '1' NOT NULL, ADD extra1 VARCHAR(250), ADD extra2 VARCHAR(250), ADD extra3 VARCHAR(250), ADD extra4 VARCHAR(250), ADD extra5 VARCHAR(250), ADD extra6 VARCHAR(250), ADD thumbnail INT(15) DEFAULT '0' NOT NULL failed with error: Duplicate column name 'sortorder'
ALTER TABLE categories DROP INDEX lastphoto failed with error: Can't DROP 'lastphoto'; check that column/key exists
ALTER TABLE categories DROP INDEX thumbnail failed with error: Can't DROP 'thumbnail'; check that column/key exists
ALTER TABLE iponline DROP INDEX userid failed with error: Can't DROP 'userid'; check that column/key exists
ALTER TABLE photos DROP INDEX approved failed with error: Can't DROP 'approved'; check that column/key exists
ALTER TABLE photos DROP INDEX date failed with error: Can't DROP 'date'; check that column/key exists

Done! You can now remove this file and check out your new Admin Options layout!

------------

Preparing to update 4.8.2 database...

Performing MySQL command: INSERT INTO settings VALUES (166,'BotBuster Integration', 'botbuster', 'Set to yes if you have BotBuster on your system (this includes the necessary tag)', 'no', 22, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (167,'Enable ZLIB page compression', 'compression', 'Set to on if you want to enable Zlib page compression (and it is supported)', 'no', 23, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (168,'Date format', 'ppdateformat', 'Keywords: dow, month, mm, dd, yyyy', 'dow dd month yyyy', 24, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (169,'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter the offset here.', '0', 25, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (170,'Enable IP Cache Timeout', 'ipcache', 'This variable is used to track IP addresses and userids for voting and viewing purposes. This is set in HOURS. 0 disables this setting', '24', 26, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (171,'PhotoPost Cookie Path', 'cookie_path', 'This should be set to match the path/domain for your cookies. Setting to / enables entire site.', '/', 1, 12) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (172,'Forum Cookie Prefix', 'cookieprefix', 'Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_', 'bb', 2, 12) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (173,'PhotoPost Cookie Domain', 'domain_path', '.yourdomain.com; sets the cookie to be usable across the domain', '.poisonfree.com', 3, 12) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (174,'Debug Setting', 'debug', 'How do you want PhotoPost to handle errors?', '2', 27, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (175,'Enable On-The-Fly Watermarks', 'onthefly', 'Requires GD2 and you must edit the file watermark.php', 'no', 29, 5) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (176,'Imaging Integration (IM or GD)', 'usegd', 'Select ImageMagick or GD1/GD2 for image processing', '1', 28, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (177,'Directory for backups?', 'backupdir', 'The full path to the directory to store backups', '/var/www/', 29, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (178,'Path to mysqldump', 'mysqldumppath', 'The full path to your mysqldump executable', '/usr/bin/mysqldump', 30, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (179,'Path to jpegtran (if used)', 'jpegtran', 'If you would like to clean any JPG image uploaded before being processed; enter the path to your jpegtran executable.', '/usr/bin/jpegtran', 18, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (180,'Path to jhead (if used)', 'jhead_command', 'This only needs to be set if you are extracting EXIF information from images. Full server path.', '/usr/bin/jhead', 19, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (181,'Gallery Open?', 'ppboards', 'Yes for Open, No for Closed', 'closed', 20, 1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (182,'Message displayed when closed', 'closedmsg', '', 'The boards are temporarily down for maintainence.', 21, 1) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (165,'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 13) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (183,'Show Peronsal Albums Index link under Members Gallery?', 'showalbum', 'Adds a text link to the Albums index into the Members Gallery description', 'yes', 10, 3) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (184,'Allow users to move their own images?','usermove', '', 'no', 16, 2) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (84,'PhotoPost Version','pversion','','4.85',53,0) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme--
Copyright 2005 All Enthusiast, Inc.',300,'0') ... Successful!
Performing MySQL command: REPLACE INTO admingroups VALUES (12,'Cookie Settings') ... Successful!
Performing MySQL command: REPLACE INTO admingroups VALUES (13,'Forum Settings') ... Successful!
Performing MySQL command: ALTER TABLE usergroups ADD uplimit INT(5) DEFAULT '0' NOT NULL ... Successful!
Performing MySQL command: ALTER TABLE categories ADD ugnovote VARCHAR(255) NULL AFTER ugnopost ... Successful!
Performing MySQL command: UPDATE settings SET title='Allow users to delete their own images?',optionorder=17 WHERE id=91 ... Successful!
Performing MySQL command: ALTER TABLE categories CHANGE catorder catorder MEDIUMINT(4) DEFAULT '9999' NOT NULL ... Successful!
Performing MySQL command: UPDATE categories SET catorder=9999 WHERE catorder=0 AND cattype='a' ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=1 WHERE id=7 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=2 WHERE id=41 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=3 WHERE id=83 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=4 WHERE id=163 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=5 WHERE id=153 ... Successful!

flint · August 28th, 2005, 11:54 AM

here´s an sql dump of the current structure, maybe you can see what´s missing, I can´t figure it out (sorry for the big postings):

-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 28. August 2005 um 18:51
-- Server Version: 4.1.13
-- PHP-Version: 5.0.4-3
--
-- Datenbank: `gallery`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `admingroups`
--

CREATE TABLE admingroups (
id int(3) NOT NULL auto_increment,
name varchar(35) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `admlog`
--

CREATE TABLE admlog (
id int(10) NOT NULL auto_increment,
adminuser varchar(50) NOT NULL default '',
description varchar(255) NOT NULL default '',
datestamp int(20) NOT NULL default '0',
ip varchar(35) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `categories`
--

CREATE TABLE categories (
id int(12) NOT NULL auto_increment,
catname varchar(255) NOT NULL default '',
description varchar(255) default NULL,
catorder mediumint(4) NOT NULL default '9999',
thumbs varchar(4) NOT NULL default 'yes',
parent int(5) NOT NULL default '0',
header varchar(200) default NULL,
footer varchar(200) default NULL,
headtags varchar(200) default NULL,
private varchar(5) NOT NULL default 'no',
ugnoview varchar(255) default NULL,
ugnoupload varchar(255) default NULL,
ugnopost varchar(255) default NULL,
ugnovote varchar(255) default NULL,
ugnoanno varchar(255) default NULL,
children text,
albums text,
lastpost int(11) unsigned default NULL,
lastphoto int(11) unsigned default NULL,
photos int(11) unsigned default '0',
posts int(11) unsigned default '0',
`password` varchar(24) default NULL,
cattype varchar(4) NOT NULL default 'c',
theme varchar(32) NOT NULL default '',
catdepth varchar(6) default NULL,
watermark varchar(250) NOT NULL default '',
sortorder int(2) NOT NULL default '1',
extra1 varchar(250) default NULL,
extra2 varchar(250) default NULL,
extra3 varchar(250) default NULL,
extra4 varchar(250) default NULL,
extra5 varchar(250) default NULL,
extra6 varchar(250) default NULL,
thumbnail int(15) NOT NULL default '0',
maximages int(12) NOT NULL default '0',
canzip char(3) NOT NULL default 'no',
frames varchar(32) default NULL,
numextra int(3) NOT NULL default '0',
intro char(3) NOT NULL default 'no',
introtitle varchar(128) default NULL,
introcopy text,
moderators text,
ratingtype int(1) NOT NULL default '0',
takevotes int(1) NOT NULL default '0',
ismember smallint(1) NOT NULL default '0',
PRIMARY KEY (id),
KEY parent (parent),
KEY lastphoto (lastphoto),
KEY thumbnail (thumbnail)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `comments`
--

CREATE TABLE comments (
id int(11) NOT NULL auto_increment,
username tinytext NOT NULL,
userid mediumint(9) NOT NULL default '0',
`date` int(15) NOT NULL default '0',
rating float(12,2) default NULL,
`comment` text NOT NULL,
photo int(11) NOT NULL default '0',
cat smallint(4) NOT NULL default '0',
approved int(2) NOT NULL default '0',
ipaddress varchar(32) default '0',
PRIMARY KEY (id),
KEY photo (photo),
KEY cat (cat)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ecards`
--

CREATE TABLE ecards (
id int(25) NOT NULL auto_increment,
fromname varchar(100) NOT NULL default '',
toname varchar(100) NOT NULL default '',
`subject` varchar(150) NOT NULL default '',
message text NOT NULL,
photoid int(25) NOT NULL default '0',
`date` int(25) NOT NULL default '0',
backcolor varchar(12) NOT NULL default '#696969',
bordcolor varchar(12) NOT NULL default '#000000',
fontcolor varchar(12) NOT NULL default '#FFFFFF',
pickfont varchar(32) NOT NULL default 'arial',
layout varchar(24) NOT NULL default 'tobottom',
returnr int(15) NOT NULL default '0',
readdate int(15) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `exif`
--

CREATE TABLE exif (
photoid int(11) NOT NULL default '0',
exifinfo text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `extrafields`
--

CREATE TABLE extrafields (
id int(12) NOT NULL auto_increment,
cat int(12) default NULL,
fieldname varchar(255) default NULL,
fieldtype char(2) default NULL,
fieldoptions text,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `favorites`
--

CREATE TABLE favorites (
id int(12) NOT NULL auto_increment,
userid int(8) NOT NULL default '0',
photo int(11) NOT NULL default '0',
PRIMARY KEY (id),
KEY parent (photo)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ipcache`
--

CREATE TABLE ipcache (
id int(10) NOT NULL auto_increment,
userid int(25) NOT NULL default '0',
ipaddr varchar(75) NOT NULL default '',
`date` int(11) unsigned default NULL,
`type` varchar(4) NOT NULL default '',
photo int(10) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `iponline`
--

CREATE TABLE iponline (
userid varchar(128) NOT NULL default '',
ipaddr varchar(75) NOT NULL default '',
`date` int(11) unsigned default NULL,
what varchar(64) NOT NULL default '',
item varchar(16) NOT NULL default '',
PRIMARY KEY (ipaddr),
KEY userid (userid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `laston`
--

CREATE TABLE laston (
cat smallint(4) NOT NULL default '0',
userid mediumint(9) NOT NULL default '0',
laston int(11) unsigned default NULL,
PRIMARY KEY (cat,userid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `notify`
--

CREATE TABLE notify (
id int(15) NOT NULL auto_increment,
userid int(25) NOT NULL default '0',
photo int(25) NOT NULL default '0',
`type` int(2) NOT NULL default '0',
PRIMARY KEY (id),
KEY photo (photo)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `photoextras`
--

CREATE TABLE photoextras (
id int(12) NOT NULL auto_increment,
photo int(12) default NULL,
extraid int(12) default NULL,
selection text,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `photos`
--

CREATE TABLE photos (
id int(10) NOT NULL auto_increment,
`user` varchar(50) NOT NULL default '',
userid int(8) NOT NULL default '0',
cat int(11) NOT NULL default '0',
storeid int(12) NOT NULL default '0',
storecat int(12) NOT NULL default '0',
`date` int(15) NOT NULL default '0',
title varchar(75) default '',
description text,
keywords varchar(150) default NULL,
bigimage varchar(100) NOT NULL default '',
width smallint(6) default NULL,
height smallint(4) default NULL,
filesize int(10) default '0',
views int(10) NOT NULL default '0',
medwidth int(12) default '0',
medheight smallint(6) default '0',
medsize mediumint(9) default '0',
approved tinyint(2) NOT NULL default '0',
lastpost int(15) NOT NULL default '0',
rating float(12,2) NOT NULL default '0.00',
watermarked varchar(5) NOT NULL default 'no',
allowprint varchar(5) NOT NULL default 'yes',
extra1 varchar(255) default NULL,
extra2 varchar(255) default NULL,
extra3 varchar(255) default NULL,
extra4 varchar(255) default NULL,
extra5 varchar(255) default NULL,
extra6 varchar(255) default NULL,
disporder int(5) NOT NULL default '99999',
ipaddress varchar(32) default '0',
numcom int(8) NOT NULL default '0',
lastposter varchar(255) default NULL,
lastpid int(8) NOT NULL default '0',
PRIMARY KEY (id),
KEY userid (userid),
KEY cat (cat),
KEY bigimage (bigimage,cat),
KEY approved (approved,storecat),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `photoviews`
--

CREATE TABLE photoviews (
photoid mediumint(9) NOT NULL default '0'
) ENGINE=HEAP DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `settings`
--

CREATE TABLE settings (
id int(11) NOT NULL auto_increment,
title varchar(255) NOT NULL default '',
varname varchar(25) NOT NULL default '',
description varchar(150) NOT NULL default '',
setting varchar(250) NOT NULL default '',
optionorder int(3) NOT NULL default '0',
section int(3) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `sort`
--

CREATE TABLE sort (
sortid int(15) NOT NULL auto_increment,
name varchar(35) NOT NULL default '',
code varchar(75) NOT NULL default '',
PRIMARY KEY (sortid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `sortmemb`
--

CREATE TABLE sortmemb (
sortid int(15) NOT NULL auto_increment,
name varchar(35) NOT NULL default '',
code varchar(75) NOT NULL default '',
PRIMARY KEY (sortid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `usergroups`
--

CREATE TABLE usergroups (
groupid int(5) NOT NULL auto_increment,
groupname varchar(50) NOT NULL default '',
cpaccess smallint(3) NOT NULL default '0',
uploads smallint(3) NOT NULL default '1',
comments smallint(3) NOT NULL default '1',
diskspace int(10) default NULL,
uploadsize int(10) default NULL,
editpho int(3) NOT NULL default '1',
editposts int(3) NOT NULL default '1',
modaccess smallint(3) NOT NULL default '0',
useralbums int(3) NOT NULL default '0',
reqmod int(3) NOT NULL default '0',
canassign int(3) NOT NULL default '0',
uplimit int(5) NOT NULL default '0',
PRIMARY KEY (groupid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `users`
--

CREATE TABLE users (
userid int(25) NOT NULL auto_increment,
usergroupid int(5) NOT NULL default '0',
username varchar(30) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
email varchar(75) NOT NULL default '',
homepage varchar(100) default NULL,
icq varchar(50) default NULL,
aim varchar(30) default NULL,
yahoo varchar(30) default NULL,
joindate int(25) NOT NULL default '0',
posts int(20) NOT NULL default '0',
birthday date NOT NULL default '0000-00-00',
ipaddress varchar(18) default NULL,
location varchar(100) default NULL,
interests varchar(250) default NULL,
occupation varchar(250) default NULL,
bio varchar(250) default NULL,
site varchar(30) default NULL,
`offset` smallint(2) NOT NULL default '0',
views int(10) NOT NULL default '0',
cellphone varchar(255) default NULL,
PRIMARY KEY (userid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Chuck S · August 28th, 2005, 12:04 PM

What I would suggest is if you know you have ran 4.85-486 since you cant run that multiple times is to download the build and upload all the files except config and make sure you run every upgrade since your last version except 485-486

A blank page on someones install suggests fields not existing in mysql or templates etc at which point php is not reporting the error and all you get is a white page

flint · August 28th, 2005, 01:16 PM

Quote:

Originally Posted by omegatron

What I would suggest is if you know you have ran 4.85-486 since you cant run that multiple times is to download the build and upload all the files except config and make sure you run every upgrade since your last version except 485-486

A blank page on someones install suggests fields not existing in mysql or templates etc at which point php is not reporting the error and all you get is a white page

to be 100% sure I uploaded the current version again.
ran all scripts again beginning with 4.5 - this time the 4.8.2 script was the last to function, all later scripts generate a blank page as well.
5.0x to 5.1 and 5.1 to 5.11 - both blank pages ...

btw, are there any issues with php5?

Chuck S · August 28th, 2005, 02:00 PM

Nope I run on Photopost on PHP 5.0

Are you sure you properly switched everything to VB3 from UBBThreads? Something has to be set wrong if you get a blank page and without any type of error being displayed all I can do is stab in the dark here.

Double check all your database settings your config file etc and make sure they all point to the right tables prefix integration etc. Do your server error logs say anything

flint · August 28th, 2005, 05:09 PM

my sysadmin showed me the magic of shell: php5 index.php - and revealed a config typo!
It´s running smoothly now, yet I have to face the broken connections due to old user id´s.