search

WoWRoster / wowroster_dev

WoWRoster Guild pages
Other
1 stars 4 forks source link

When setting up database (Fresh Install) #1

Closed nogarth closed 9 years ago

nogarth commented 9 years ago

When running the install and inserting all database information wither its a new database or current database it always bombs out with the same error and you cannot proceed

/roster/lib/dbal/mysql.php: line[238] Database Error "CREATE TABLE roster_api_items ( item_id int(11) NOT NULL, item_name varchar(96) NOT NULL, item_color varchar(16) NOT NULL, item_texture varchar(64) NOT NULL, item_tooltip mediumtext NOT NULL, level int(11) DEFAULT NULL, item_level int(11) DEFAULT NULL, item_type varchar(64) DEFAULT NULL, item_subtype varchar(64) DEFAULT NULL, item_rarity int(4) NOT NULL DEFAULT '-1', locale varchar(16) DEFAULT NULL, timestamp int(10) NOT NULL, json longtext DEFAULT NULL PRIMARY KEY (item_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8" MySQL said: 1067: Invalid default value for 'json'

I have fixed it with https://github.com/nogarth/wowroster/commit/b92f58b232820774daef8c8de61fc60f36b6b858

but after that part it fails on inserting the groups as the primary key is already used. looking at the database and entrys in there Public gets given the group_id = 1 for some reason

Ulminia commented 9 years ago

these issues have been resolved in local copy but have not updated to the repo yet

nogarth commented 9 years ago

when will the Repo be updated and i'll do some testing for you. Also do we have a source for the guildprofiler addon while wowroster.net is having problems?

Ulminia commented 9 years ago

i just pushed my most recent changes to roster

On Thu, Dec 4, 2014 at 6:14 AM, nogarth notifications@github.com wrote:

when will the Repo be updated and i'll do some testing for you. Also do we have a source for the guildprofiler addon while wowroster.net is having problems?

— Reply to this email directly or view it on GitHub https://github.com/Ulminia/wowroster/issues/1#issuecomment-65610264.

Ulminia commented 9 years ago

as for profiler it has not been updated in along time i should probably do that .. but roster sync has better support for adding a guild now

On Thu, Dec 4, 2014 at 7:22 AM, joe foster ulminia@gmail.com wrote:

i just pushed my most recent changes to roster

On Thu, Dec 4, 2014 at 6:14 AM, nogarth notifications@github.com wrote:

when will the Repo be updated and i'll do some testing for you. Also do we have a source for the guildprofiler addon while wowroster.net is having problems?

— Reply to this email directly or view it on GitHub https://github.com/Ulminia/wowroster/issues/1#issuecomment-65610264.

nogarth commented 9 years ago

thanks Ulminia