OK, so I set up the 0.1b release on my server as per the instructions. I set up the database by running the initial script for that and it created the tables and as far as I know I configured the db config file correctly. However, when I try loading the whole thing up instead of a login page I get a blank screen. The error logs are shown below. Any ideas?
[13-Jul-2006 00:32:33 +0100] DB Error: DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='1c5311baab486867393345c7d30843dc' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist] in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 455
[13-Jul-2006 00:32:33] PHP Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 343
[13-Jul-2006 00:36:27 +0100] DB Error: DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='5ea8ce77e647c625daf1fd069f5dafeb' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist] in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 455
[13-Jul-2006 00:36:27] PHP Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 343
[13-Jul-2006 00:36:31 +0100] DB Error: DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='11d5a41f6ad42793f28b645022f63f8b' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist] in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 455
[13-Jul-2006 00:36:31] PHP Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 343
[13-Jul-2006 00:39:12 +0100] DB Error: DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='1f5321d5bd5ea2a0f2a83dd9b926b7d7' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist] in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 455
[13-Jul-2006 00:39:12] PHP Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 343
[13-Jul-2006 00:39:16 +0100] DB Error: DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='eaaf05f214ca39a71035b293f8b808a7' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist] in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 455
[13-Jul-2006 00:39:16] PHP Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 343
[13-Jul-2006 00:47:57 +0100] DB Error: DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='9a370863d48ade6fb1de595400d7ac04' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist] in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 455
[13-Jul-2006 00:47:57] PHP Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 343
[13-Jul-2006 08:39:44 +0100] DB Error: DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='f417f4e4ba3d444007f5c655acc99bdd' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist] in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 455
[13-Jul-2006 08:39:44] PHP Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 343
[13-Jul-2006 08:41:45 +0100] DB Error: DB Error: connect failed in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 97
[13-Jul-2006 08:41:46] PHP Fatal error: Call to undefined function: query() in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 213
[13-Jul-2006 08:41:54 +0100] DB Error: DB Error: connect failed in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 97
[13-Jul-2006 08:41:54] PHP Fatal error: Call to undefined function: query() in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 213
[13-Jul-2006 08:45:21 +0100] DB Error: DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='d0b76137a1f66f64af20a1f815d98582' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist] in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 455
[13-Jul-2006 08:45:21] PHP Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 343
[13-Jul-2006 08:48:05 +0100] DB Error: DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='8e3ff1b57dfc992f85e495f873e53a7e' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist] in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 455
[13-Jul-2006 08:48:05] PHP Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 343
[13-Jul-2006 11:12:40 +0100] DB Error: DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='bdefe136653ef872dfe6dadc7075b123' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist] in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 455
[13-Jul-2006 11:12:40] PHP Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 343
[13-Jul-2006 15:00:24 +0100] DB Error: DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='cfdb9c8225911b7f92a7164951825c01' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist] in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 455
[13-Jul-2006 15:00:24] PHP Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 343
Added code tags.
I'm having the same issue. I am running on Apache server, cPanel, MySql version 5.0.18-standard, PHP version 4.4.2
I changed the files specified in the config folder, then uploaded, went to index.php, and nothing, just a blank screen. Did I miss something?
i've got the same problem
looked for "blank page" on the forums but found no answers
please help!
Well seems like the sessions table is missing from the SQL setup... which file did you execute: mySQL initial or mySQL Update? You want the initial one.
Then in the config files, is auto_create_user true or false? You want true at first to create the users, then you can restrict it.
It also looks like you have some connection errors in the mix with that.....
Best bet: Dump the entire database (drop all the tables). Then execute the mysql.initial.sql file from the 0.1b SQL folder. That should have everything you need. Then try again.
i had the same problem and i found my error.. though i think it`s also a error in the error reporting of this good looking script :) i did edited my db configuration and saved it... but apperently it wasn`t saved because when i looked in another time i still got the default pass... won`t work :)
But the error of this script is that it just stays silent.. it must point out that a connection can`t be made!! not just say nothing.. that`s bad!! :) o well.. i`m gonna try and login now and play with this eye candy script
@to the creators..
really wonderfull that you guys make such a buatifull script for free under the gpl licence :) good job so far!! O0
Well, it can show that there was an error, you just have to turn error reporting up. By default, it's set ot just log it so it gracefully fails ;)
<>
It was the initial one initially...though I did run the other one as well
<>
It's true
<>
Able to help a bit more on this one?
<>
I did this, and there's still this lovely blank page :-[
Mark:
Beta 2 just came out, try giving that a shot.
ok, I'm up to beta 2 now, and I've changed the error logging method, so if you go to http://www.markporter.co.uk/mail/ you can see the error, it's still pretty much the same;
DB Error in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc (479): DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='1944873d2fcb28683e1b78c00f902384' [nativecode=1146 ** Table 'markporter_co_uk.session' doesn't exist]
Fatal error: Call to a member function on a non-object in /home/httpd/vhosts/markporter.co.uk/httpdocs/mail/program/include/rcube_db.inc on line 367
I'm thinking something:
You changed the name of the mySQL table somehow and didn't update the db.inc.php file.
I got this error initially when I started putting different builds on the same site. I would separate the tables by buildNumber__tableName It worked, but I always had an issue of missing one table.
I'd suggest you open your phpMyAdmin and look at the table names. Also open your db.inc.php file and look at those names. And just to make sure, when you've verified the names are correct, overwrite the db.inc.php file and try again.
Other than that, I'd need FTP access to really get down to the nitty gritty to see what's going on.
hmm. tried renaming the tables and that didn't help. Think I'd rather not give FTP access, so guess I might have to leave it there.
Right...it's fixed now - I gave the thing to my hosting guys and they sorted it out for me, apparently the issues were as follows;
<1) add a line in the initial sql file that you have to run to make it use the right database.
2) removed the .htaccess file in the main directory as I don't believe it was critical and it was causing errors.>>
Glad to hear you got it sorted.
Can you give me some insight into what was added to the sql file? I am having the same problem and I have deleted the .htaccess files and played with the hostname but I still get a blank screen. Thanks!
<>
I'm afraid I really don't know... I did go onto my database admin and was rather surprised that I couldn't see any of the table there though...don't quite understand what my guys did.
Ok, thanks for letting me know.
Does anyone else think they can help me? Thanks!
How you are running the initial script?
Do you have phpMyAdmin or something similar to make sure they are there?
I would assume they added something like a use data_name command....
http://dev.mysql.com/doc/refman/5.1/en/use.html
Not sure what your asking about the internal script?
I do have access to phpmyadmin, there are 6 tables and all have data within them.
How would I use that data_name command? Create the query for each table that needs to be tied to the speicific database? Then run the query in phpmyadmin? Thanks!