On Thu, Sep 26, 2013 at 4:14 PM, Lucian Velea <[email protected]> wrote: > Hello,
Hi Lucian, > I have a multilanguage cultural site and a group of volunteers want to > translate the interface for all languages. I think Pootle would be > great, but I have troubles with the setup. > > I asked my hosting support to setup Pootle. It seemed fine. Then I > switched to MySQL and I changed some other configuratioon settings. > Pootle reported an error, MySQL library for Python was missing. My > hosting support installed it, I can see the Pootle tables in MySQL > database, but Pootle doesn't work. Which Pootle version used the previous deployment? Which Pootle version uses the current deployment? Was the previous Pootle deployment using the SQLite database? How the database was switched to MySQL? > The web interface reports: > > The proxy server received an invalid response from an upstream server. > The proxy server could not handle the request GET /. > Reason: Error reading from remote server > > At the console, Pootle reports something like this: > > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xD0\xA1\xD1\x83\xD1\x80...' for co > lumn 'target_f' at row 1 > return self.cursor.execute(query, args) > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xD0\x9E\xD1\x81\xD0\xB2...' for co > lumn 'target_f' at row 1 > return self.cursor.execute(query, args) > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xD0\x9E\xD0\xB1\xD0\xB8...' for co > lumn 'target_f' at row 1 > return self.cursor.execute(query, args) > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xC2\x97 2 \xC3...' for column 'dev > eloper_comment' at row 1 > return self.cursor.execute(query, args) > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xD0\xA0\xD0\xB5\xD0\xB8...' for co > lumn 'target_f' at row 1 > return self.cursor.execute(query, args) > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xC2\x83\xC3\x82\xC2\xAB...' for co > lumn 'target_f' at row 1 > return self.cursor.execute(query, args) > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xD0\x92\xD1\x80\xD0\xB0...' for co > lumn 'target_f' at row 1 > return self.cursor.execute(query, args) > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xD0\x9A\xD0\xBE\xD1\x80...' for co > lumn 'target_f' at row 1 > return self.cursor.execute(query, args) > 2013-09-26 10:08:26,533 WARNING Data integrity error while importing > unit available: > (1062, "Duplicate entry '27-e4894ca167b08880bfc35862f18575eb' for key > 'store_id'") > 2013-09-26 10:08:26,760 WARNING Data integrity error while importing > unit average: > (1062, "Duplicate entry '27-6927a3a7218a3195858411433ec20a21' for key > 'store_id'") > 2013-09-26 10:08:27,029 WARNING Data integrity error while importing > unit axis: > (1062, "Duplicate entry '27-433169d5d9bcbb6d43f0d288e68f0cad' for key > 'store_id'") > 2013-09-26 10:08:27,448 WARNING Data integrity error while importing > unit backbone: > (1062, "Duplicate entry '27-d70ae7b16a386a69116b097e282af76b' for key > 'store_id'") > 2013-09-26 10:08:27,676 WARNING Data integrity error while importing > unit back-end: > (1062, "Duplicate entry '27-a115a25065b29adfe4c0b73391cd5b3a' for key > 'store_id'") > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xC8\x9Bie b...' for column 'target > _f' at row 1 > return self.cursor.execute(query, args) > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xC5\xA5' for column 'target_f' at > row 1 > return self.cursor.execute(query, args) > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xC9\xB2ooje' for column 'target_f' > at row 1 > return self.cursor.execute(query, args) > 2013-09-26 10:09:08,635 WARNING Data integrity error while importing > unit background: > (1062, "Duplicate entry '27-d229bbf31eaeebc7c88897732d8b932d' for key > 'store_id'") > 2013-09-26 10:09:08,887 WARNING Data integrity error while importing > unit backup: > (1062, "Duplicate entry '27-402051f4be0cc3aad33bcf3ac3d6532b' for key > 'store_id'") > 2013-09-26 10:09:09,063 WARNING Data integrity error while importing > unit bandwidth: > (1062, "Duplicate entry '27-36676c2be80fcce669845428b1577be9' for key > 'store_id'") > 2013-09-26 10:09:09,346 WARNING Data integrity error while importing > unit banner: > (1062, "Duplicate entry '27-12df53fea8b3adfa6c2ec456dd22e204' for key > 'store_id'") > /usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:114: > Warning: Incorrect string value: '\xC4\x8Det' for column 'target_f' a > t row 1 > return self.cursor.execute(query, args) > 2013-09-26 10:09:09,594 WARNING Data integrity error while importing > unit bar: > (1062, "Duplicate entry '27-37b51d194a7513e45b56f6524f2d51f2' for key > 'store_id'") > > Can you help? This seems like you have a corrupted database. Do you have a backup of the previous database? Based on the information I can't provide a good recommendation on how to proceed now. Please provide answers for the questions above. > All the best, > Lucian Velea ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk _______________________________________________ Translate-pootle mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/translate-pootle
