update auf vb3: use a scalar value as an array in

[kaiandeve]

Hi ihr,

bin beim update auf vb3.
habe hier eine lokale kopie des forums wo ich sicherheitshalber testen wollte.
Nun bekomme ich folgende meldung:
--------------------------------------
Step 3) Upgrade Calendar

Renaming calendar_events to event
Altering event Table (1 of 5)
Altering event Table (2 of 5)
Altering event Table (3 of 5)
Altering event Table (4 of 5)
Altering event Table (5 of 5)

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 919

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 921

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 923

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 925

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 929

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 931

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 933

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 935

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 937

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 938

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 940

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 941

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 943

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 944

-----------------------------
habs vorhin immer weitergeklickt bis zum ende der installation (das sind ja über 100 klicks :eek: .
Am Ende ging aber gar nichts mehr :-(

[kaiandeve]

das sind die zeilen 914-944
--------------------------------------------

$query[] = "ALTER TABLE event
DROP eventdate";
$explain[] = $upgrade_phrases['upgrade1.php']['droping_event_date'];

$query[] = "ALTER TABLE event
CHANGE subject title VARCHAR(254) NOT NULL";
$explain[] = $upgrade_phrases['upgrade1.php']['changing_subject_to_title'];

// Create a private and public calendar

$query[] = "INSERT INTO calendar (title, description, displayorder, startofweek, options, cutoff, eventcount, birthdaycount)
VALUES ('{$upgrade_phrases['upgrade1.php']['public']}', '{$upgrade_phrases['upgrade1.php']['public_calendar']}', 1, 1, 119, 15, 5, 2)";
$explain[] = $upgrade_phrases['upgrade1.php']['creating_pub_calendar'];

$query[] = "INSERT INTO calendar (title, description, displayorder, startofweek, options, cutoff, eventcount, birthdaycount)
VALUES ('{$upgrade_phrases['upgrade1.php']['private']}', '{$upgrade_phrases['upgrade1.php']['private_calendar']}', 2, 1, 118, 15, 5, 2)";
$explain[] = $upgrade_phrases['upgrade1.php']['creating_priv_calendar'];

$query[] = 'UPDATE event SET calendarid = 1 WHERE public = 1';
$explain[] = $upgrade_phrases['upgrade1.php']['moving_pub_events'];

$query[] = 'UPDATE event SET calendarid = 2 WHERE public = 0';
$explain[] = $upgrade_phrases['upgrade1.php']['moving_priv_events'];

$query[] = 'ALTER TABLE event DROP public';
$explain[] = $upgrade_phrases['upgrade1.php']['drop_public_field'];

[kaiandeve]

es gibt bei mir keine tabelle "event"

meine jetzige version ist übrigends:
vBulletin v2.3.2

[kaiandeve]

ach jetzt sehe ichs
er hat calender_events in events umbenatnnt
das hat funktioniert - aber was soll dann die fehler meldung?

[kaiandeve]

so habe nun nochmal ein update auf 2.3.6 gemacht und das update auf vb3 dann gestartet - mit dem gleichen erfolg :-(

[kaiandeve]

wenn man die installation weiter klickt:
-----------------------------------------------

Step 21) Alter Usergroup Table

Altering usergroup Table (1 of 9)
Altering usergroup Table (2 of 9)
Altering usergroup Table (3 of 9)
Altering usergroup Table (4 of 9)
Altering usergroup Table (5 of 9)
Altering usergroup Table (6 of 9)
Altering usergroup Table (7 of 9)
Altering usergroup Table (8 of 9)
Altering usergroup Table (9 of 9)
Updating some usergroup titles
Updating Usergroup Permissions

Usergroup: Registered ... Done.
Usergroup: Users Awaiting Email Confirmation ... Done.
Usergroup: (COPPA) Users Awaiting Moderation ... Done.
Usergroup: Super Moderators ... Done.
Usergroup: Administrators ... Done.
Usergroup: Moderators ... Done.
Usergroup: Unregistered / Not Logged In ... Done.

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2263

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2264

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2279

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2286

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2288

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2296

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2298

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2304

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2309

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2315

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2318

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2323

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2325

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2330

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2332

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2336

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2338

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2343

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2345

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2350

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2352

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2359

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2361

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2364

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2366

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2371

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2375

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2382

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2384

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2389

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2391

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2396

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2398

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2403

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2405

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2410

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2412

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2417

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2419

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2424

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2426

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2431

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2432

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2437

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2439

Warning: Cannot use a scalar value as an array in \install\upgrade1.php on line 2443

[kaiandeve]

das ist in zeile 2263 und 2264

$query[] = "UPDATE usergroup SET pmquota = IF(canusepm, " . iif($pmquota == 0, 10000, $pmquota) . ", 0)";
$explain[] = $upgrade_phrases['upgrade1.php']['updating_usergroups'];

[kaiandeve]

so - 120 klicks später - fertig installiert.
admincp läuft (wie vorhin auch).
aber wenn man auf die forumsstartseite geht kommt:
---------------------------------------------------
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT eventid, userid, title, recurring, recuroption, dateline_from, dateline_to, calendarid, IF (dateline_to = 0, 1, 0) AS singleday,
dateline_from AS dateline_from_user, dateline_to AS dateline_to_user, utc
FROM event AS event
WHERE ((dateline_to >= 1111532400 AND dateline_from < 1111705200) OR (dateline_to = 0 AND dateline_from >= 1111532400 AND dateline_from <= 1111705200 ))
AND visible = 1

mysql error: Unknown column 'title' in 'field list'

mysql error number: 1054

Date: Wednesday 23rd of March 2005 09:09:29 PM
Script: http://localhost:9000/forum1/index.php?
Referer: http://localhost:9000/forum1/admincp/index.php?do=head
Username: kai
IP Address: 127.0.0.1
------------------------------------------------------
ich weis nicht weiter :-(

[kaiandeve]

so - habs mal komplett neu installiert.
nun gehts - aber das nützt mir nicht wirklich was.
ich muss ja das update machen :-(

[kaiandeve]

habs gefunden *froi*
habe die einträge in der event tabelle verglichen und gefunden das die "title" fehlt - habe sie erstellt und nun wird das forum angezeigt :-)
hoffntlich geht auch alles - müßte doch oder?

[Mystics]

Wenn sonst nichts fehlt, ja.

[kaiandeve]

hi,
man weis es ja nicht genau - es sind ja schließlich ein haufen tabellen - mit nochmehr feldern und einträgen...

gruß Kai

p.s.: warum hat man die instllation "klickbar" gemacht und lässt es nicht automatisch durchlaufen - über 100 klicks zum installieren sind doch ganz schön lästig :-)