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

Re: SMF-ezportal_column_5.cache): failed to open stream: No such file or directory by EzPortal
June 04, 2022, 11:40:13 am

SMF-ezportal_column_5.cache): failed to open stream: No such file or directory by Shades
June 04, 2022, 11:29:37 am

Re: Arcade block error: failed to open stream: No such file or directory by Shades
May 20, 2022, 02:47:13 pm

Re: ezPortal 5.5 by EzPortal
May 20, 2022, 09:59:30 am

Re: ezPortal 5.5 by tigez
May 20, 2022, 08:46:15 am

Re: Undefined index: href by Shades
May 16, 2022, 02:58:21 pm

Re: Image/Attachment display issue by Shades
May 16, 2022, 02:28:35 pm

Re: Undefined index: href by Shades
May 16, 2022, 02:27:16 pm

+- HTML Menu


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

Recent Topics ezBlock

SMF-ezportal_column_5.cache): failed to open stream: No such file or directory by EzPortal
June 04, 2022, 11:40:13 am

Arcade block error: failed to open stream: No such file or directory by Shades
May 20, 2022, 02:47:13 pm

ezPortal 5.5 by EzPortal
May 20, 2022, 09:59:30 am

Undefined index: href by Shades
May 16, 2022, 02:58:21 pm

Image/Attachment display issue by Shades
May 16, 2022, 02:28:35 pm

Can't delete custom actions by Shades
April 13, 2022, 12:53:28 pm

Newest Member ezblock by Shades
March 23, 2022, 12:48:32 pm

Random Download Block by Shades
March 22, 2022, 10:37:47 am

BBC Pages by EzPortal
March 21, 2022, 10:36:41 pm

Recent Topics Blocks are different from left side to right side by Shades
March 21, 2022, 02:42:38 pm

Author Topic: Database error on Board News ezBlock  (Read 20134 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: 1289
  • Karma: 67
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: 1289
  • Karma: 67
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
7112 Views
Last post December 05, 2008, 08:54:52 pm
by EzPortal
4 Replies
7451 Views
Last post January 21, 2009, 07:24:23 am
by EzPortal
9 Replies
14745 Views
Last post November 17, 2011, 06:29:23 pm
by EzPortal
1 Replies
10521 Views
Last post October 01, 2012, 12:58:32 pm
by n1k
3 Replies
6544 Views
Last post September 13, 2016, 09:26:04 am
by twc1968

+-SMF Gallery

Quick Menu


Powered by EzPortal