Installations and Upgrades

[John]

This is a general call for comment and feedback and suggestions on how the upgrade and installation scripts work.

Is there anything that would make them easier for you? More fool-proof? Are there any resources that we should make available for you to aid in the procedure?

Let us know, and we will try and incorporate your suggestions into future scripts!

Thanks,

John

[orca]

The install and update scripts are ok. May the update scripts should display the changed templates at the end again. And include a file with the name of the changed files. That would be really helpfull.

[The Prohacker]

I had was messing with an PHP script that would connect to a ftp server and move and change files. And got to thinking, why couldn't Jelsoft have a script that after a person purcheses vB, they have the option to have the script call up their server, and ftp the files over, alter the config.php, and then initiate the MySql setup. This could help with some of the users that have problems installing vB, and would possibly reduce some trouble tickets made because of bad installs....

But of course, this would reduce the reveune brought in by Jelsoft employees installing it for customers, but it wouldn't go competely away.....


Just a thought...

[Chen]

Two things.

First one is checking for ALTER permissions before even trying to start the script.
I know a lot of members that start upgrading, and somewhere in the middle gut stuck because they didn't have permission to use ALTER.
(this might be fixed in the latest script though, not sure. :) just posting...)

Second is changing the way templates are installed.
Instead of just deleting all templates and adding them all over again, why not having something like this:
$counter=0;
$changetemplates='';
while ($counter++<$numtemplates) {
list($devnull,$title)=each($stylebits);
list($devnull,$template)=each($stylebits);
if (trim($title)!="" and $changecheck=$DB_site->query_first("SELECT templateid FROM template WHERE title='".addslashes($title)."' AND template='".addslashes($template)."'")) {
$DB_site->query("UPDATE template SET template='".addslashes($template)."' WHERE title='".addslashes($title)."')"); // changed from INSERT
$changetemplates.=$title;

}
}
(of course remove the query that deletes all defualt templates)
That way, we know EXACTLY which templates were changed, and the devs / us don't need to report each and every template they edit.
(and I realize it's a bit slower, having to run a query for each template. but the benefit is great, IMO)