https://bugzilla.wikimedia.org/show_bug.cgi?id=9767





--- Comment #69 from D J Bauch <[email protected]>  2009-05-05 18:56:53 UTC ---
(In reply to comment #68)
> (In reply to comment #67)
> > (In reply to comment #66)
> > > After some fixes on php.ini (most important is to set a file for error 
> > > log for
> > > not getting 500 errors), my installation is moving.
> > > first I found that tables.sql has to be in maintenance/sqlserver (and not 
> > > in
> > > mssql dir). then after creating some tables it stops.
> > > 
> > > 
> > >  refreshing the installation give this info:
> > >  There are already MediaWiki tables in this database. Checking if updates 
> > > are
> > > needed... 
> > >  ...ipblocks table does not exist, skipping new field patch
> > >  ...ipblocks table does not exist, skipping new field patch
> > >  Creating interwiki table: 
> > > 
> > > then it stop...
> > > 
> > > could be that tables.sql that is provided here is broken ?
> > > 
> > 
> > There is no maintenance/sqlserver directory, and 
> > maintenance/mssql/tables.sql
> > has an entry for ipblocks.
> > 
> but DatabaseADODB.php has this on line 1360:
>  dbsource( "../maintenance/sqlserver/tables.sql", $this);
> 
> And for some reason the table creation fail at the middle, these table were
> created:
> * user2
> * user_newtalk
> * user_groups
> * text
> * templatelinks
> * revision2
> * pagelinks
> * page2
> * imagelinks
> * categorylinks
> * archive
> 
> And these views were created:
> * page
> * revision
> * user
> 
> There are missing about 20-30 other tables...
> 

I am starting to fix this. The problem is that the way the tables are initially
created has changed since I created my wiki. I'll have to update
./maintenance/updaters.php and add a SQL Server case to the function
archive($name) so that it looks in "$IP/maintenance/archives/sqlserver". Right
now it is trying to use the MySQL archives (since the only other option
currently is postgress. I'll have to populate that directory under maintenance.
If you just run the SQL in ./maintenance/sqlserver/tables.sql, you should get
all the current tables.


-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to