Page 1 of 1

Deleteing install_portal/install.php causes sql eror

Posted: 2. December 2008 22:07
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.

Re: Deleteing install_portal/install.php causes sql eror

Posted: 9. December 2008 17:21
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:

Re: Deleteing install_portal/install.php causes sql eror

Posted: 9. December 2008 21:40
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?

Re: Deleteing install_portal/install.php causes sql eror

Posted: 17. December 2008 05:19
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.