Kristoff1875 Posted March 31, 2014 Share Posted March 31, 2014 Not sure what's caused it, but on one of my tables, all of the related values all seem to be invisible? https://www.dropbox.com/s/vqtgw0az44isu1t/Screenshot%202014-03-31%2019.22.51.png When calling results it displays them properly and when running a search they all display, just not in the browse tab. Anyone got any ideas? Cheers Quote Link to comment Share on other sites More sharing options...
Psycho Posted March 31, 2014 Share Posted March 31, 2014 Perhaps all of the values have a line break at the beginning? Quote Link to comment Share on other sites More sharing options...
Kristoff1875 Posted March 31, 2014 Author Share Posted March 31, 2014 They're all integers and the ones that aren't visible are all linked from other tables , yet all the other tables display the values fine. Quote Link to comment Share on other sites More sharing options...
Psycho Posted March 31, 2014 Share Posted March 31, 2014 What do you mean they are "linked from another table". Are you saying the image you provided is the result of a query with a JOIN? You'll need to provide the data from the relevant tables and the query you are using if we are to understand the details. Quote Link to comment Share on other sites More sharing options...
Kristoff1875 Posted March 31, 2014 Author Share Posted March 31, 2014 My Races Table, note RaceID 50000 https://www.dropbox.com/s/vwha17y80h9kgw8/Screenshot%202014-03-31%2019.47.13.png This is my Results table which did have data that tied up with the other tables, such as RaceID 50000 did show up, but now all related values have vanished. Here is the browse tab: https://www.dropbox.com/s/1t6m9gcu0cj52vx/Screenshot%202014-03-31%2019.48.01.png Here is select all search: https://www.dropbox.com/s/902xthpzgvusq9l/Screenshot%202014-03-31%2019.49.26.png Quote Link to comment Share on other sites More sharing options...
jazzman1 Posted April 1, 2014 Share Posted April 1, 2014 Weird! Maybe it's a bug. Does that happen only to this particular database/table? What specific permissions have the user to this database/tables? Is this a root account? Quote Link to comment Share on other sites More sharing options...
Kristoff1875 Posted April 1, 2014 Author Share Posted April 1, 2014 This is accessing from cpanel in to phpmyadmin, I have access to all of my tables. I deleted the table and started again, as soon as I relate them, they vanish. Quote Link to comment Share on other sites More sharing options...
jazzman1 Posted April 1, 2014 Share Posted April 1, 2014 I am not sure where the problem is, but have you tried - REPAIR TABLE db_name.table_name. The other method that could try is to export table data to sql file, then drop the table and restore it from the same dump sql file. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.