Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Inconsistent database issue


Reply


4 Posts   1267 Views

Avatar
Marlie511

Community Member, 36 Posts

5 October 2010 at 4:01am

When I go to files and images tab, I get this error:
[Warning] Inconsistent database issue: SELECT ID FROM `File` WHERE Name = '' AND ParentID = 0 should have returned data

This happened after I was reorganizing the files folder in the files/images tab.
Any idea on what I can do to fix this?

Thanks!

Avatar
Marlie511

Community Member, 36 Posts

6 October 2010 at 5:02am

Ok, I went into Mysql Query browser and deleted everything in the file table.
Opened Firefox and ran a db/build
Then logged into the web site and selected the Files/Images Tab and everything it rebuilt the table list.
All is working now, except my File list pages. They don't show anything in there.

Avatar
carlos

Community Member, 41 Posts

8 October 2010 at 3:08pm

Hi,

Which version of SilverStripe are you using? db/build has been deprecated, you should use dev/build now (I thing since 2.3).

regards Files, what are you trying to do?

cheers
Carlos

Avatar
ttyl

Community Member, 114 Posts

9 October 2010 at 3:10am

Edited: 09/10/2010 3:11am

there is also

/dev/tasks/FilesystemSyncTask

and

/dev/tasks/FlushGeneratedImagesTask