On Friday, April 26, 2013 4:10:02 AM UTC-5, Mike Hadmack wrote: > > Hi Everyone, > > I just got Mayan set up and working on a test server with a few dozen > documents. Now I am trying to migrate the database and document files to > my production server and things are not working out well. Document > thumbnails generally seem to appear okay with the exception of pre-xml MS > Office files. However when I view my OCR queue I have a number of issues: > > 1) Several documents in the queue just appear stuck, the have > status='processing' and result='None' indefinitely. When I try to requeue > or delete them I get a message saying that I can't because they are being > processed. > > 2) Most of my pdf files show status='error' with a result like "Incorrect > string value: '\xEF\xAC\x82In(...' for column 'content' at row 1". This > seems to be a unicode error so I made sure that I dumped and restored my > mysql database in a utf8 safe manner when migrating to the new server. > These error did not appear on the test server. > > 3) My mayan_error.log file if full of errors like: "DatabaseError: > (1146, "Table 'mayan.common_anonymoususersingleton' doesn't exist")" I > have checked that this table does exist in the mysql database. > > I dumped my database using: `mysqldump -u root -p mayan -r mayan.sql` and > restored using: > mysql> drop database mayan; > mysql> CREATE DATABASE mayan DEFAULT CHARACTER SET utf8 DEFAULT COLLATE > utf8_general_ci; > mysql> grant all privileges on mayan.* to 'mayan'@'127.0.0.1' with grant > option; > mysql> use mayan > mysql> source mayan.sql > > Does anyone have any idea what is going on here? Thanks. > > -Mike > > Not a clue, but I'm having the same problem. Tried a number of things. I could get the "stuck documents" unstuck by going in and manipulating the database directly, but that's probably not the best way, and eventually OCR stops again.
-Jon -- --- You received this message because you are subscribed to the Google Groups "Mayan EDMS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
