Forum Subject: Run SQL
Posted on: 05/29/02 08:12am
By: Anonymous (Roman)
I'm trying to install the weather plug-in and it says:
Run the SQL script: weather-sql.sql
How do I run the script? Yeah I know it's amazing that I actually got my site up and running. 
try phpmyadmin
Posted on: 05/29/02 09:32am
By: squatty
In my opinion, this is a must have tool for anyone running MySQL and PHP....You can download the code here[*1] . I've even got a hack for integrating phpmyadmin with Geeklogs security ;-) (not ready for publishing yet....).
Once you have phpmyadmin up and running, simply copy and paste the SQL code into the "Run SQL query/queries on database" text box and click GO!
The alternative approach is to use MySQL command line.
using mysql command line
Posted on: 05/29/02 09:43am
By: Tony
try this with mysql from command line:
#>mysql -u<username> -p<password> <database_name> < <sqlfilename>.sql
If you have questions, do "man mysql"
try phpmyadmin
Posted on: 05/29/02 04:15pm
By: Anonymous (Anonymous)
Thanks! I'm running phpmyadmin on my server now. I ran the weathersql.sql, but at first it didn't work. I had to change two lines in the sql to gl_userprefs...it was looking for just userprefs.
I have the block on the page now, but when I hit edit or details, I get the following message:
1146: Table 'tribalx_geeklog.userindex' doesn't exist
I also get the following additional errors on details:
Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of fsockopen(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /home/tribalx/public_html/geeklog/public_html/weather/weather_details.php on line 108
Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of fsockopen(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /home/tribalx/public_html/geeklog/public_html/weather/weather_details.php on line 108
Warning: Cannot add header information - headers already sent by (output started at /home/tribalx/public_html/geeklog/public_html/weather/weather_details.php:108) in /home/tribalx/public_html/geeklog/system/lib-sessions.php on line 263
Warning: Cannot add header information - headers already sent by (output started at /home/tribalx/public_html/geeklog/public_html/weather/weather_details.php:108) in /home/tribalx/public_html/geeklog/system/lib-sessions.php on line 150
Warning: Cannot add header information - headers already sent by (output started at /home/tribalx/public_html/geeklog/public_html/weather/weather_details.php:108) in /home/tribalx/public_html/geeklog/system/lib-sessions.php on line 162
Any ideas?
try phpmyadmin
Posted on: 05/29/02 04:28pm
By: Anonymous (Roman)
well I got it working except for the following messages on the top of the details page....
Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of fsockopen(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /home/tribalx/public_html/geeklog/public_html/weather/weather_details.php on line 108
Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of fsockopen(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /home/tribalx/public_html/geeklog/public_html/weather/weather_details.php on line 108
Warning: Cannot add header information - headers already sent by (output started at /home/tribalx/public_html/geeklog/public_html/weather/weather_details.php:108) in /home/tribalx/public_html/geeklog/system/lib-sessions.php on line 263
Warning: Cannot add header information - headers already sent by (output started at /home/tribalx/public_html/geeklog/public_html/weather/weather_details.php:108) in /home/tribalx/public_html/geeklog/system/lib-sessions.php on line 150
Warning: Cannot add header information - headers already sent by (output started at /home/tribalx/public_html/geeklog/public_html/weather/weather_details.php:108) in /home/tribalx/public_html/geeklog/system/lib-sessions.php on line 162
try phpmyadmin
Posted on: 05/29/02 07:23pm
By: squatty
Good to hear you've made it this far....
As for your question:
The warnings are being thrown by your PHP interrupter. By default, PHP will display all messages to a client's browser. In a production environment you should modify the default PHP logging to ERROR only. To do this edit your php.ini file as follows:
Set error_reporting to E_ERROR, the line should look like this:
error_reporting = E_ERROR