search

noldmess / EagleEye

EagleEye
5 stars 1 forks source link

SQL-errors with SQLite #6

Open enko opened 10 years ago

enko commented 10 years ago

I wanted to try eagleeye with sqlite, but it fails as I wanted to open the application:

An exception occurred while executing 'ALTER TABLE"oc_facefinder_tag_photo_module" ADD FOREIGN KEY (photo_id) REFERENCES oc_facefinder(photo_id) ON DELETE CASCADE ON UPDATE CASCADE': SQLSTATE[HY000]: General error: 1 near "FOREIGN": syntax error

As SQLite does not support the alter table syntax, tt would seem better to me to use the mdb2 schema foo, to create the foreign key, have a look at this so question.

HTH

Tim

mckaygerhard commented 9 years ago

ping?

i hope this project does not develop under the mysql borry dbms.. and support real dbms

noldmess commented 9 years ago

sorry it is mysql

mckaygerhard commented 9 years ago

well u must need to change something due owncloud works with 3 kind of dbms and 2 more super scalar, owncloud are made to server thousand of thousand of files, if u'r plugin (very promised but as i noted) does not work with scalar thousand of data, will be hard to u mantain and develop for real usage..