Hi, I've just upgraded to the latest version, but I am now getting this error:
Error While Checking Podcasttable : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=InnoDB)' at line 1
BR
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi.
thanks for you response, but it did not work me..
even though i changed things like 'LastUpdate INTEGER UNSIGNED' to 'LastUpdate INT UNSIGNED' same error appears
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hmm. I just checked and it works for me. Looking at your first post
'ENGINE=InnoDB)'
implies there's a bracket after InnoDB, that shouldn't be there and it isn't there in my copy. Can I suggest you download the release again and try again?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi.
I just downloaded it again, and this time I did not rsync to the folder with the old version, but deleted the old rompr folder (1.05) and copied the new, unzipped folder to htdocs but it is again this error.
I will just switch back to 1.05 which works nicely...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ah. I've found the error. Bad code design :) There's a typo in the released file that I woudn't have found when I tested it. I've attached a new version of
rompr/backends/sql/mysql/specifics.php
Please try this with the 1.07 release, I'm pretty sure it will fix the problem.
Hi, I've just upgraded to the latest version, but I am now getting this error:
BR
Whoops. Thanks for reporting. I seem to have forgotten to test that release with MySQL...
I will be releasing a new version very soon but it isn't finished yet. For the time being if you want to fix the error yourself, open
and search and replace all appearances of INTEGER with the word INT (case sensitive)
It's a simple typo from copying-and-pasting from the SQLite code.
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
Hi.
thanks for you response, but it did not work me..
even though i changed things like 'LastUpdate INTEGER UNSIGNED' to 'LastUpdate INT UNSIGNED' same error appears
Hmm. I just checked and it works for me. Looking at your first post
implies there's a bracket after InnoDB, that shouldn't be there and it isn't there in my copy. Can I suggest you download the release again and try again?
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
Hi.
I just downloaded it again, and this time I did not rsync to the folder with the old version, but deleted the old rompr folder (1.05) and copied the new, unzipped folder to htdocs but it is again this error.
I will just switch back to 1.05 which works nicely...
Very weird. 1.08 should be out soon. I've tested that here and I'm not getting any error. But then I tested 1.07 too and that also worked for me.
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
Shall I drop the database and let rompr create new tables etc? Would that help maybe?
Ah. I've found the error. Bad code design :) There's a typo in the released file that I woudn't have found when I tested it. I've attached a new version of
Please try this with the 1.07 release, I'm pretty sure it will fix the problem.
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
Perfect. It is up and running again now. Thanks a lot!