Forum Replies Created

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter drsack

    (@drsack)

    I apologize. Under league manager I see folders labeled; “admin, css, images, languages, lib, sports, templates.” Can you tell me where to look for the column names of the tables.

    Thread Starter drsack

    (@drsack)

    Here is the error I received today when updating to new version. Same error I received last week. This error repeats about 30 times.

    Upgrade LeagueManager
    Upgrade database structure…

    WordPress database error: [Unknown column ‘profile’ in ‘field list’]
    SELECT title, website, coach, stadium, logo, home, group, roster, profile, points_plus, points_minus, points2_plus, points2_minus, add_points, done_matches, won_matches, draw_matches, lost_matches, diff, league_id, id, season, rank, status, custom FROM wp_leaguemanager_teams WHERE league_id = ‘2’ ORDER BY rank ASC,id ASC

    Thread Starter drsack

    (@drsack)

    Thread Starter drsack

    (@drsack)

    I do not get any error messages. It will say ‘team added’ but does not show the team. Everything appears to work normal but the teams do not show up.

    I did delete project manager but that did not help.

    Thread Starter drsack

    (@drsack)

    I have deleted project manager but that did not help. I have tried adding a team and it says “team added” but will not show the team.

    [ 700+ lines of CSS redacted ]

    Thread Starter drsack

    (@drsack)

    I deactivated projectmanager. No luck. I deleted it and reinstalled. No luck. I checked my database user priviliges and they are all set and correct.

    When I click on an old league the standings appear for less then a second and then are gone.

    Thread Starter drsack

    (@drsack)

    When updating the plugin it said it needed to update the project manager database. Then I received these error messages:

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_projectmeta’]
    ALTER TABLE wp_projectmanager_projectmeta ADD options varchar ( 255 ) NOT NULL default ”

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_projectmeta’]
    ALTER TABLE wp_projectmanager_projectmeta ADD mandatory tinyint( 1 ) NOT NULL default ‘0’ AFTER order_by

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_projectmeta’]
    ALTER TABLE wp_projectmanager_projectmeta ADD unique tinyint( 1 ) NOT NULL default ‘0’ AFTER mandatory

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_projectmeta’]
    ALTER TABLE wp_projectmanager_projectmeta ADD private tinyint( 1 ) NOT NULL default ‘0’ AFTER unique

    WordPress database error: [DROP command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_countries’]
    DROP TABLE wp_projectmanager_countries

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_countries’]
    ALTER TABLE wp_projectmanager_countries ADD name_locale varchar( 200 ) NOT NULL default ” AFTER name

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_dataset’]
    ALTER TABLE wp_projectmanager_dataset ADD sticky tinyint( 1 ) NOT NULL default ‘0’ AFTER image

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_countries’]
    ALTER TABLE wp_projectmanager_countries ADD region_code varchar( 3 ) NOT NULL default ” AFTER name_locale

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_countries’]
    ALTER TABLE wp_projectmanager_countries ADD region_name varchar( 200 ) NOT NULL default ” AFTER region_code

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_countries’]
    ALTER TABLE wp_projectmanager_countries ADD code2 varchar( 2 ) NOT NULL default ” AFTER region_name

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_projectmeta’]
    ALTER TABLE wp_projectmanager_projectmeta ADD label_type varchar( 50 ) NOT NULL default ” AFTER show_in_profile

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_projectmeta’]
    ALTER TABLE wp_projectmanager_projectmeta ADD newline tinyint( 1 ) NOT NULL default ‘1’ AFTER label_type

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_projectmeta’]
    ALTER TABLE wp_projectmanager_projectmeta ADD width int( 3 ) NOT NULL default ‘100’ AFTER newline

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_projectmeta’]
    ALTER TABLE wp_projectmanager_projectmeta CHANGE label label longtext NOT NULL default ”

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_dataset’]
    ALTER TABLE wp_projectmanager_dataset ADD status varchar( 255 ) NOT NULL default ” AFTER order

    WordPress database error: [ALTER command denied to user ‘yscr_bb6Am5’@’localhost’ for table ‘wp_projectmanager_dataset’]
    ALTER TABLE wp_projectmanager_dataset ADD activationkey varchar( 255 ) NOT NULL default ” AFTER status

    Thread Starter drsack

    (@drsack)

    The problem happened when updating from 4.0.5 to 4.0.6

    Everything looks OK except the teams do not show up and the standings tables are blank.

    I can add new leagues-but when I try and add new teams nothing happens.

    Here is a photo of a league that has 16 teams and the matches/standings were entered last October and worked fine. Now it looks like this.

    http://dccityball.com/dccityball/wp-admin/admin.php?page=leaguemanager&subpage=show-league&league_id=139

    Thread Starter drsack

    (@drsack)

    I use the plugin for several sports (softball, football, basketball, volleyball). The errors came during the update-I did not write them down.

    The update was shown as successful-but my old standings are no longer visible and I cannot add any new teams.

Viewing 9 replies - 1 through 9 (of 9 total)