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

New built in translations for six langauges! by EzPortal
March 26, 2024, 11:15:32 pm

Smiley missing in shoutbox 2.1.4 by hustreamload
July 26, 2023, 08:14:02 am

Re: Theme Select Box question? by Shades
March 15, 2023, 06:49:49 pm

Re: Theme Select Box question? by Shades
March 09, 2023, 02:09:24 pm

Re: Theme Select Box question? by Shades
March 09, 2023, 01:55:53 pm

Re: Theme Select Box question? by EzPortal
March 09, 2023, 01:47:42 pm

Re: Theme Select Box question? by Shades
March 09, 2023, 01:34:07 pm

Re: Theme Select Box question? by EzPortal
March 09, 2023, 12:20:17 pm

+- HTML Menu


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

Recent Topics ezBlock

New built in translations for six langauges! by EzPortal
March 26, 2024, 11:15:32 pm

Smiley missing in shoutbox 2.1.4 by hustreamload
July 26, 2023, 08:14:02 am

Theme Select Box question? by Shades
March 15, 2023, 06:49:49 pm

Where is the facebook button color? by EzPortal
February 28, 2023, 06:45:09 pm

Display on Mobile - SMF 2.1.3 and EZ 5.5.2 by BugginIn
December 29, 2022, 04:07:13 pm

Blocks Help by Riggs1973
November 20, 2022, 12:59:30 pm

Surface ol lite theme release Free! by Steffen K.
November 18, 2022, 03:57:24 am

Undefined index: href by EzPortal
October 04, 2022, 08:49:59 pm

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

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

+-SMF Gallery

Quick Menu


Powered by EzPortal