No standings display and cannot add new teams

well, it would be helpful if you told us what error codes you got? and some more information on what sport type you use

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.

I won’t be able to help you on this, I cannot guess and my clairvoyance skills are also a bit rusty…

From what version to what version did you upgrade?
Did you check your database?
What about adding a new league?
Do you get any error messages?

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.

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

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

These errors are not from upgrading LeagueManager, but ProjectManager. Your issue, however, comes from a problem with your database priviliges, which I cannot help you with. Check your database settings and priviliges for your user. Make sure that your database user has all priviliges for the database.

For now try deactivating projectmanager and see what happens

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.

Apparently your database user priviliges were not sufficient as they lacked ALTER and DROP!

You need to check all wp_projectmanager and wp_leaguemanager tables and post the table columns so I can see if any are missing.

Do you not get any error messages on the standings page or when you try adding a team?

Did you also delete ProjectManager and checked the standings page or tried adding a team?

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 ]

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.

@drsack Please do not post that many lines of CSS. If you can post a link to your site then that would help. Or use https://pastebin.com/ and post the link to that new paste.

https://dccityball.com/dccityball/standings/

please post the column names of all wp_leaguemanager and wp_projectmanager tables

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

I am not surprised by the error message. As I have stated before: your database user was or still is lacking the privilege to ALTER a databsae. Therefore, your database tables are lacking required columns.

I have asked you twice already to post the column names of your wp_leaguemanager and wp_projectmanager tables, which you haven’t even commented on …