 | [Solved] Statistics mod, help needed |  |
 Posted: 05/23/2007 9:05 AM |
 |
|
|
|
|
| Citation |
| Posts |
556 |
| Word Cnt. |
20,326 |
| BDay |
Jan 26 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Nov 26, 2006
Local time: 12:30 AM
Location: west midlands:uk
|
|
|
|
|
 |
It installed great but when i click on statistics i get this error:
| Code:
|
Module last_created_album_posts has a problem:
Couldn't retrieve album post data
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 p.pic_cat_id IN () AND u.user_id = 3 ORDER BY p.pic_time DESC LIMI' at line 5
SQL Statement: SELECT u.user_timezone, u.user_dateformat, p.pic_id, p.pic_title, p.pic_time, p.pic_user_id, p.pic_username, p.pic_desc FROM phpbb_users AS u, phpbb_album_cat AS c LEFT JOIN phpbb_album AS p ON c.cat_id = p.pic_cat_id WHERE (p.pic_user_id <> -1) AND c.cat_id IN () AND p.pic_cat_id IN () AND u.user_id = 3 ORDER BY p.pic_time DESC LIMIT 10
DEBUG MODE
SQL Error : 1064 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 p.pic_cat_id IN () AND u.user_id = 3 ORDER BY p.pic_time DESC LIMI' at line 5
|
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Statistics mod, help needed | |
| Posted: 05/23/2007 5:25 PM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Apr 01, 2007
Local time: 3:30 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
You need to create the tables, therefore we run install/install_statistics.php (http://www.yoursite.com/phpBB2/install/install_statistics.php) Please be sure to enter the correct URL, the install_statistics.php file has to be placed within the install folder.
Executing install/install_statistics.php will also install all current available modules. After it is run successfully, you should delete the file form that install folder which you have just uploaded.
Let me know what happens
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Statistics mod, help needed | |
| Posted: 05/23/2007 5:33 PM |
|
|
|
|
|
| Citation |
| Posts |
556 |
| Word Cnt. |
20,326 |
| BDay |
Jan 26 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Nov 26, 2006
Local time: 12:30 AM
Location: west midlands:uk
|
|
|
|
|
|
| i already did that, then i clicked on statistics and i got that error above |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Statistics mod, help needed | |
| Posted: 05/23/2007 5:35 PM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 3:30 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
Some problem related to album MOD or statistics and album MOD problem. Than I am not sure what's the problem so let's wait for Nightrider and we will see what is the problem and how to solve it  |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Statistics mod, help needed | |
| Posted: 05/23/2007 5:42 PM |
|
|
|
|
|
| Citation |
| Posts |
556 |
| Word Cnt. |
20,326 |
| BDay |
Jan 26 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Nov 26, 2006
Local time: 12:30 AM
Location: west midlands:uk
|
|
|
|
|
|
| yea ok, thanks for your help |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Statistics mod, help needed | |
| Posted: 05/23/2007 5:46 PM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 3:30 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
No problem. Thanks for Nightrider because whatever I know, it's all because of him  |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Statistics mod, help needed | |
| Posted: 05/24/2007 1:54 PM |
|
|
|
|
|
| Citation |
| Posts |
556 |
| Word Cnt. |
20,326 |
| BDay |
Jan 26 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Nov 26, 2006
Local time: 12:30 AM
Location: west midlands:uk
|
|
|
|
|
|
Think its the same to all of us here lol  |
|
|
|
|
| Back to Top |
|
|
| Re: Statistics mod, help needed | |
| Posted: 05/24/2007 5:07 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:30 PM
Location: St Pete, FL
|
|
|
|
|
|
There was a newer version of this MOD, so I uninstalled it and removed the database changes for 4.2.4, then installed 4.2.5 on your Test board. When running the database update file, this was listed at the bottom of the page:
| Quote:
|
Module 'Last Online' is installed but is set inactive because it requires 'Last Visit Mod' (http://www.phpbbhacks.com/download/237) to be installed.
Module 'most_ignored_users' is installed but is set inactive because it requires 'Ignore Users Mod' (http://www.phpbbhacks.com/download/789) to be installed.
Module 'most_logged_on_users' is installed but is set inactive because it requires 'Last Visit Mod' (http://www.phpbbhacks.com/download/237) to be installed.
Module 'advancedkarma' is installed but is set inactive because it requires 'Advanced Karma Mod' (http://siava.ru/forum/topic168.html) to be installed.
Module 'Genders' and module 'Posts by Gender' are installed but are set inactive because they requires 'Gender Mod' made by Niels Chr. Denmark (http://phpbbhacks.com/download/182) to be installed.
Module 'Genders (eviL3)' and module 'Posts by Gender_(eviL3)' are installed but are set inactive because it requires 'Gender MOD' made by eviL3 (http://www.phpbb.com/phpBB/viewtopic.php?t=467168) to be installed.
Module 'Age Statistics' is installed but is set inactive because it requires 'Birthday Hack' (http://www.phpbbhacks.com/viewhack.php?id=187) to be installed.
Module pak Activity_Arcade_Top_xx_Users_Game_Plays.pak has more install instruktions, take a look in /modules/pakfiles/Install_Activity_Mod_Top_10_Users_Game_Plays
Module 'Top Countries (IpCountryFlags)' is installed but is set inactive because it requires IpCountryFlags (http://www.you3d.net/ip2/index.php
|
Even after doing that, it didn't correct the problem. I will continue looking into it...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Statistics mod, help needed | |
| Posted: 05/24/2007 5:13 PM |
|
|
|
|
|
| Citation |
| Posts |
556 |
| Word Cnt. |
20,326 |
| BDay |
Jan 26 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Nov 26, 2006
Local time: 12:30 AM
Location: west midlands:uk
|
|
|
|
|
|
Ok, no probs  |
|
|
|
|
| Back to Top |
|
|
| Re: Statistics mod, help needed | |
| Posted: 05/24/2007 5:24 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:30 PM
Location: St Pete, FL
|
|
|
|
|
|
Ok, I created a tmp subfolder inside of your modules folder and moved the following folders to it:
- last_created_album_posts
- most_viewed_photos_ever
- most_viewed_photos_this_month
- most_viewed_photos_this_week
Do you even have these MODs installed? Other than the Warning errors at the top of the page caused by the missing module folders listed above, it seems to be working now. If those MODs are not installed on your board, then those records can be removed so that the Warning errors will go away:
http://toddlersandbabies.co.uk/test/statistics.php
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
![[ Hidden ]](templates/Helius_blue/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
