EzPortal - Portal Software for Forums

EzPortal - Made to Fit Your SMF Forum - Glad You Found Us!
+- +-

UserBox

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Recent Posts

Minor Update for SMF 2.1.x by EzPortal
October 18, 2020, 09:33:09 am

Re: EzPortal unable to be seen by user with primary custom usergroup by EzPortal
October 12, 2020, 07:55:08 am

EzPortal unable to be seen by user with primary custom usergroup by radi27
October 11, 2020, 04:46:32 pm

Show Likes mod by NickT
July 10, 2020, 12:09:44 pm

Re: ezPortal inbuilt module downloaders not working. by EzPortal
March 26, 2020, 08:19:48 am

Re: ezPortal inbuilt module downloaders not working. by Valdivia
March 26, 2020, 08:16:33 am

Re: ezPortal inbuilt module downloaders not working. by EzPortal
February 12, 2020, 10:01:42 pm

Re: ezPortal inbuilt module downloaders not working. by usalabs
February 12, 2020, 05:59:54 pm

+- HTML Menu


Sample HTML Block Usage - You May Custom Code it, as needed!

Author Topic: Database error on Board News ezBlock  (Read 18366 times)

0 Members and 1 Guest are viewing this topic.

Offline Black Tiger

  • Newbie
  • *
  • Posts: 4
  • Karma: 0
Database error on Board News ezBlock
« 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?

Offline EzPortal

  • Administrator
  • *****
  • Posts: 1227
  • Karma: 66
Re: Database error on Board News ezBlock
« Reply #1 on: March 07, 2014, 10:21:31 pm »
Will check into those issues as soon as possible.
Like ezPortal? Support me at https://www.patreon.com/vbgamer45/

Offline Black Tiger

  • Newbie
  • *
  • Posts: 4
  • Karma: 0
Re: Database error on Board News ezBlock
« Reply #2 on: March 08, 2014, 06:04:53 am »
That would be great, thank you very much!

Offline EzPortal

  • Administrator
  • *****
  • Posts: 1227
  • Karma: 66
Re: Database error on Board News ezBlock
« Reply #3 on: March 10, 2014, 09:53:55 am »
Just released ezPortal 2.0 which should take care of those issues!
Like ezPortal? Support me at https://www.patreon.com/vbgamer45/

Offline Black Tiger

  • Newbie
  • *
  • Posts: 4
  • Karma: 0
Re: Database error on Board News ezBlock
« Reply #4 on: March 10, 2014, 10:26:36 am »
Thanks.

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
5756 Views
Last post December 05, 2008, 08:54:52 pm
by EzPortal
4 Replies
6078 Views
Last post January 21, 2009, 07:24:23 am
by EzPortal
9 Replies
12977 Views
Last post November 17, 2011, 06:29:23 pm
by EzPortal
1 Replies
9344 Views
Last post October 01, 2012, 12:58:32 pm
by n1k
3 Replies
5138 Views
Last post September 13, 2016, 09:26:04 am
by twc1968

+-SMF Gallery

Quick Menu



Members Online

16 Guests, 0 Users
Powered by EzPortal