|
Quotes |
" ... I want to tell you that your thyme product is functional and valuable beyond
words. I cannot imagine why any portal would be without it. It is the cornerstone of our new project ..."
" ... Thanks for such a complete project, its making my job much easier. ..."
" ... I have now deployed 4 different calendars and our users love them ... "
" ... Easy to install and use and a great look/design. ..."
" ... This has to be the easiest to use program I think I've had to deal with at all this year. ..."
|
|
| View previous topic :: View next topic |
| Author |
Message |
DJ Machismo
Joined: 18 Mar 2008 Posts: 13
|
Posted: Tue Mar 18, 2008 8:07 pm Post subject: MySQL Error When Creating Mini Calendar |
|
|
I've tried creating a Mini Calendar module that we can use above our main menu on our website. However just going through the Joomla Studio and creating a new mini calendar will immediately give us this error message:
| Code: |
Error!: class.mysql.php :: query() :: 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 ') order by lower(title)' at line 2
select id, title from Calendars
where id in () order by lower(title) |
The mini calendar will display below that however. Trying to make sure we fix this error before we can get the mini calendar ready to go on the live website. |
|
| Back to top |
|
 |
esoft_ian
Joined: 12 Sep 2005 Posts: 5268
|
Posted: Wed Mar 19, 2008 5:19 pm Post subject: |
|
|
Hi,
Can you make sure you are up to date in Admin -> Installer -> Updates please? Also, what do you have for calendar in the General settings of your Joomla Studio project? |
|
| Back to top |
|
 |
DJ Machismo
Joined: 18 Mar 2008 Posts: 13
|
Posted: Wed Mar 19, 2008 6:18 pm Post subject: |
|
|
| I did the updates and that fixed the problem, thanks. |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|