Deleteing install_portal/install.php causes sql eror

Current Version: 1.0.6
Released: 09.01.10
Forum rules
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
Locked

Topic author
ssei95
Active Member
Posts: 6
Joined: 2. December 2008 21:54

Deleteing install_portal/install.php causes sql eror

Post by ssei95 »

Your Portal Version: 1.0.0RC3
Your phpBB Type: Standard phpBB3
MODs installed: Yes
Your knowledge: Basic Knowledge

What have you done before the problem was there?
New install of the portal.

What have you already tryed to solve the problem?
Tried running the installer again.

Description and Message
I was able to install the portal and all seems fine. I can navigate to and from the portal and it integrated great with the board. When I go to remove the file .../install_portal/install.php the portal then fails and gives me this error:

Code: Select all

SQL ERROR [ mysql4 ]

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 'AND in_message = 0 ORDER BY filetime DESC' at line 4 [1064]
[/i]

EDIT: After trying various simple things, I found that the file name only is what it is looking for. I placed an empty file called install.php in the location and the portal came back online. Not sure what or where would be referencing that file.

Topic author
ssei95
Active Member
Posts: 6
Joined: 2. December 2008 21:54

Re: Deleteing install_portal/install.php causes sql eror

Post by ssei95 »

WOW... Figured this one out I think... I renamed the directory by adding characters to the end of the "install_portal" folder name. Apparently the portal.php still parsed out the original name form it. Once I added the additional characters to the front of the folder name, SQL error went away and all looks fine now. Porblem was my fault, but it's fixed now. :oops:
User avatar

Kevin
Site Admin
Posts: 2989
Joined: 7. January 2006 20:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg
Contact:

Re: Deleteing install_portal/install.php causes sql eror

Post by Kevin »

That is odd. This code in the portal.php is responsible for this:

Code: Select all

if ( is_dir( $phpbb_root_path . 'install_portal/' ) === TRUE ) 
So if you even name it install_portalxxx it shouldn't blame you anymore.
May i ask which Database and PHP Version do you use?
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!

Topic author
ssei95
Active Member
Posts: 6
Joined: 2. December 2008 21:54

Re: Deleteing install_portal/install.php causes sql eror

Post by ssei95 »

I'm using phpbb 3.01 and Mysql 5.0.51a-community

I found that code when I was troubleshooting, and tried removing/editing it with no luck (I'm not that good at php yet). That was all I found, which is why I was confused. Either way, the portal is live on my board and people are loving it! One of the best mods I ever added.
Locked

Return to “board3 Portal 1.0.x - English Support”