EzPortal - Portal Software for Forums

EzPortal Forums => Support => Topic started by: Black Tiger on March 07, 2014, 08:08:23 pm

Title: Database error on Board News ezBlock
Post by: Black Tiger on March 07, 2014, 08:08:23 pm
I tried the Board News ezBlock. It started already by giving an error notice because I couldn't leave the amount of characters per entry to 0. Which is strange because there it says 0=unlimited.
So I changed it to 100 and it worked. But that was a littlebit to less.

So I changed 100 to 150 and the problems began to happen. I got a database error. I had an ad mod installed, so I uninstalled that, and things worked once, but then the database error occured again.

I'm using SMF 2.0.7 with the latest ezPortal (just installed via package manager).
This is the database error:
Quote
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 ID_FIRST_MSG DESC
LIMIT 0, 5' at line 3
File: /home/username/public_html/forum/Sources/Subs-EzPortalMain2.php
Regel: 2375

I had to disable admin view permission, otherwise I wasn't able to make changes anymore, so I was lucky that I succeeded in that by using the back button on the browser.
I have deleted the block and made it again, same problem.

I added some screenshots. On the first, you can see what is happening when a normal user is looking at the portal with the news block activated.

The second and third screenshot provide my settings of the block, which is in the center module.
The left side is only the user block at the moment, and at the right side a html block with adsense code in it.

How can this be fixed?
Title: Re: Database error on Board News ezBlock
Post by: EzPortal on March 07, 2014, 10:21:31 pm
Will check into those issues as soon as possible.
Title: Re: Database error on Board News ezBlock
Post by: Black Tiger on March 08, 2014, 06:04:53 am
That would be great, thank you very much!
Title: Re: Database error on Board News ezBlock
Post by: EzPortal on March 10, 2014, 09:53:55 am
Just released ezPortal 2.0 which should take care of those issues!
Title: Re: Database error on Board News ezBlock
Post by: Black Tiger on March 10, 2014, 10:26:36 am
Thanks.