http://www.wpwp.org/forums/tags/mysql WassUp Forums » Tag: mysql - Recent Posts en-US Thu, 09 Feb 2012 08:11:40 +0000 http://bbpress.org/?v=1.0.3 q http://www.wpwp.org/forums/search.php http://www.wpwp.org/forums/topic/is-this-plug-in-still-under-development#post-1079 Tue, 23 Nov 2010 23:16:44 +0000 umutweb 1079@http://www.wpwp.org/forums/ <p>Wow, the 1.8 UI looks awesome. :) </p> http://www.wpwp.org/forums/topic/is-this-plug-in-still-under-development#post-1052 Thu, 16 Sep 2010 22:37:10 +0000 Lisa 1052@http://www.wpwp.org/forums/ <p>Thank you.</p> <p>Will version 1.8 also work with cache plugins such as W3 Total Cache? </p> http://www.wpwp.org/forums/topic/is-this-plug-in-still-under-development#post-1051 Wed, 15 Sep 2010 01:59:17 +0000 helene 1051@http://www.wpwp.org/forums/ <p>Hi Lisa,</p> <p>I am glad you want to keep using WassUp in spite of it's database size. </p> <p>I may be able to squeeze in the "2 week" summary option into v1.8, if it doesn't delay the release. </p> http://www.wpwp.org/forums/topic/is-this-plug-in-still-under-development#post-1050 Wed, 15 Sep 2010 00:58:12 +0000 Lisa 1050@http://www.wpwp.org/forums/ <p>Thank you Helene,</p> <p>I stopped using Wassup as a longterm stats tool, the server demands are just to high to keep data for a year.</p> <p>However it is an excellent plugin to see day to day and week tot week stats. So is it possible to have auto database deletes and summary for the last:</p> <p>2 weeks<br /> 3 weeks </p> http://www.wpwp.org/forums/topic/is-this-plug-in-still-under-development#post-1048 Tue, 14 Sep 2010 23:13:51 +0000 helene 1048@http://www.wpwp.org/forums/ <p>Wassup 1.8 improves Wassup's performance, however, there is no significant change to the database structure itself. This improvement may allow you to retain data for longer than 1 month (3 months), without significant slowdowns, however, the database size will still be large.</p> <p>You may need a faster, more optimized host server to use WassUp. If that's not possible, another plugin that uses a remotely-hosted stats service that does not affect your database may be more appropriate for you. Google Analytics and Wordpress.com Stats are good examples of these. </p> http://www.wpwp.org/forums/topic/is-this-plug-in-still-under-development#post-1045 Sun, 12 Sep 2010 23:03:27 +0000 Lisa 1045@http://www.wpwp.org/forums/ <p>Will 1.8 fix the huge database size that Wassup created?</p> <p>I had it running on a website with 150.000 visitors a month and the database was 750mb after 6 months. It was huge and really slowed down the server. I set it's recording to max 1 month, but 1 month is too short for me. </p> http://www.wpwp.org/forums/topic/is-this-plug-in-still-under-development#post-1025 Tue, 22 Jun 2010 08:40:40 +0000 gstek 1025@http://www.wpwp.org/forums/ <p>Just waiting for final release ... </p> http://www.wpwp.org/forums/topic/is-this-plug-in-still-under-development#post-1024 Sat, 19 Jun 2010 20:06:41 +0000 umutweb 1024@http://www.wpwp.org/forums/ <p>Thank you. :) I love this plug-in, and I would be very sorry if it was cancelled. </p> http://www.wpwp.org/forums/topic/is-this-plug-in-still-under-development#post-1023 Sat, 19 Jun 2010 16:21:10 +0000 helene 1023@http://www.wpwp.org/forums/ <p>Wassup is still under development. Michele and I are both busy, but we are very committed to this project.</p> <p>Wassup status as of today, 2010-06-19: Revision 1.8 has come out of alpha phase and will be available for beta testing soon. </p> http://www.wpwp.org/forums/topic/is-this-plug-in-still-under-development#post-1022 Fri, 18 Jun 2010 19:54:51 +0000 umutweb 1022@http://www.wpwp.org/forums/ <p>Hello.<br /> There is a while since last upgrade. Is this plugin is under development or depreceated? </p> http://www.wpwp.org/forums/topic/table-repair-button-does-nothing#post-926 Tue, 08 Dec 2009 00:26:19 +0000 GeoffreyTransom 926@http://www.wpwp.org/forums/ <p>Hi again Helene,</p> <p>What I eventually had to do was to create the wp_wassup table directly in a mySQL client. I made wassup.php echo $sql_createtable from line 1693, and ran the script by hand in a mySQL client.</p> <p>Wassup is now collecting/storing/displaying data just as it was intended - and its interface seems much quicker that "StatPress Reloaded".</p> <p>Thanks for your help,</p> <p>GT </p> http://www.wpwp.org/forums/topic/table-repair-button-does-nothing#post-919 Wed, 11 Nov 2009 22:46:26 +0000 helene 919@http://www.wpwp.org/forums/ <p>Thanks for providing details about your Wordpress setup. It was very helpful.</p> <p>It looks like WassUp is attempting to use the wrong table prefix for your wordpress database and can't create the tables required. I will attempt to duplicate your unusual table prefix on my test system to see if I can find and fix the bug. </p> <p>The "cannot redeclare" errors are a separate issue caused by multiple attempts to install Wassup. Your uninstall/deactivation likely also failed due to the table prefix error and Wassup option settings have remained intact in your Wordpress options table. Those options need to be purged manually because any re-install of WassUp will reuse those setting, including the wrong table prefix.</p> <p>To completely uninstall Wassup, first deactivate Wassup (yes, it activated despite the activation error message from Wordpress). Then, after deactivation finishes, click on "plugins" again (or reload the page) and double-check that Wassup is really deactivated. Then, delete the "wassup" folder completely from your "plugins" directory. Next, go to your phpMyAdmin manager (available from most ISP's), select your wordpress database and select wordpress "options" table (normally called "wp_options") in the left frame. Select "Browse" in the right frame and look for the row labeled "wassup_settings" under the "options_name" column and delete it (click the "X" at the beginning of the row). Be extra careful not to delete anything else as that can be disasterous.</p> <p>You may have to wait for the next bug fix revision of WassUp before you can use Wassup with your configuration. Or, you can go ahead and edit Wassup plugin file to insert the correct table prefix that wassup needs to run in your setup. To do this, install a clean copy of Wassup, but DON'T activate it, then go to "Plugins"-&gt;"Editor", select wassup file "wassup.php", and edit line #63 in the "wassup_install()" function and change the "$table_name" variable declaration to:</p> <blockquote><p><code>$table_name = &quot;marketme_wrdp1&quot;. &quot;wassup&quot;;</code></p> </blockquote> <p> Then activate Wassup. Good luck!.</p> <p>FYI. For security reasons, you should not publish your Wordpress absolute path in these forums, even those in error messages. Next time, remove the beginning part of the path and only show the section after and including "/wp-content/". Michele, if you read this, please truncate the full path in this thread. Thanks.</p> <p>NOTE to others reading these instructions: Don't attempt these changes! It is specific to this one case only. If you want to uninstall WassUp, go to WassUp-&gt;Options, select the "Uninstall" tab, Save, and then deactivate Wassup. That is the correct way to completely uninstall Wassup. </p> http://www.wpwp.org/forums/topic/table-repair-button-does-nothing#post-918 Mon, 09 Nov 2009 23:01:24 +0000 GeoffreyTransom 918@http://www.wpwp.org/forums/ <p>Hi there Helene,</p> <p>My hosting is Apache 2.0.63, running PHP 5.2.8 (safe mode OFF) and mySQL 5.1.34-log.</p> <p>I can't think of anything unusual about my WP install - WP source is in /WPDir and home directory is / (I'm using WP as a CMS).</p> <p>One thing is that my WP database has a prefix - instead of wrdp1 it's called marketme_wrdp1, but that's recorded in wp-config as usual.</p> <p>The issue seems to arise at install - when I try to activate I get </p> <pre><code>Fatal error: Cannot redeclare wassup_install() (previously declared in /home2/marketme/public_html/WPBlog/wp-content/plugins/wassup/wassup.php:59) in /home2/marketme/public_html/WPBlog/wp-content/plugins/wassup/wassup.php on line 194</code></pre> <p>The bizarre thing is that line 194 is the closing bracket for wassup_install(); it has a curly brace and a comment. There is no attempt to declare a new function (that said, the error trace might be off).</p> <p>If I simply plough on after this error, Wassup appears as activated in the plugin set, but no mySQL tables are generated in my Wordpress mySQL database during the Wassup install process. I can set all the parameters, but I get that message about the table wp_wassup not existing - which is good, because the table doesn't exist.</p> <p>I notice that in a few places in in wassup.php that there are places where $wpdb-&gt;query() has been replaced by mysql_query(), as in<br /> <pre><code>//$wpdb-&gt;query(&quot;DROP TABLE IF EXISTS $table_tmp_name&quot;); //incorrectly causes an activation error in Wordpress</code></pre> <p>I couldn't see anything of that nature in wassup_install() though.</p> <p>Cheers</p> <p>GT </p> http://www.wpwp.org/forums/topic/table-repair-button-does-nothing#post-914 Sat, 07 Nov 2009 17:35:13 +0000 helene 914@http://www.wpwp.org/forums/ <p>Thank you for reporting this problem. We will doublecheck for compatibility issues in Wordpress 2.8.5. To help us diagnose this problem, can you provide more info. about your server settings such as the host server type (Apache or IIS), MySQL version and engine, PHP version, and whether PHP is in safe mode. Also, is your Wordpress configuration unusual in any way? </p> http://www.wpwp.org/forums/topic/table-repair-button-does-nothing#post-913 Wed, 04 Nov 2009 21:43:31 +0000 GeoffreyTransom 913@http://www.wpwp.org/forums/ <p>Update: Uninstall/reinstall did zip. </p> http://www.wpwp.org/forums/topic/table-repair-button-does-nothing#post-912 Wed, 04 Nov 2009 21:41:38 +0000 GeoffreyTransom 912@http://www.wpwp.org/forums/ <p>Oops - I should mention: I verified in an SQL client that there are no WassUp tables in the wrdp1 database. </p> http://www.wpwp.org/forums/topic/table-repair-button-does-nothing#post-911 Wed, 04 Nov 2009 21:40:33 +0000 GeoffreyTransom 911@http://www.wpwp.org/forums/ <p>Hi there,</p> <p>I just installed WassUp (v 1.7.2.1); I am running WP 2.8.5.</p> <p>When I installed WassUp I got a 'fatal error' message during pplugin activation. I ahd a look at this forum, and that error had been described in other forum messages,: the solution seemed to be to wait while something happened in the background, so I did that.</p> <p>The plugin then appeared to be activated, but when I went to set the Option, the following text appeared in red:</p> <p><code>IMPORTANT: WassUp table empty or does not exist. Click &#39;repair&#39; button to rebuild it now ==&gt; [repair]</code></p> <p>However the [repair] text is not clickable and the mySQL tables still don't exist.</p> <p>Is this an 'uninstall-reinstall' issue?</p> <p>Cheerio</p> <p>GT </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-789 Fri, 29 May 2009 18:39:08 +0000 helene 789@http://www.wpwp.org/forums/ <p>Snowgasm,<br /> Thank you for providing your server config info. We have noted a syntax compatibility problem with Wassup 1.7.1 and the MySQL engine "innoDB" which you have. To fix, go to Wordpress Admin==&gt;Plugins==&gt;Editor, under "Select Plugin to Edit", select Wassup, scroll down to line #2391 and change<br /> <blockquote><code>$delayed=&quot;DELAYED&quot;; //for delayed insert</code><br /> to<br /> <code>$delayed=&quot;&quot;; //for delayed insert</code></p></blockquote> <p>Click "Update File", and you are done and WassUp should start recording again.<br /> This bug will be fixed in the next revision coming soon. </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-788 Fri, 29 May 2009 18:02:08 +0000 helene 788@http://www.wpwp.org/forums/ <p>SaW...I do NOT recommend commenting out the cookie. It is important to WassUp tracking. Your error is someplace else and it is affecting WassUp's ability to write the cookie. Try disabling all Spam check in WassUp. Also triple-check your wp-config.php file. Because white spaces are not visible to the eye, you should rebuild it from a copy of wp-config-sample.php and do NOT copy and paste between old and new as that will also copy white spaces. Edit with "NotePad" or "Vi", NOT Wordpad or Word. </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-786 Fri, 29 May 2009 09:51:44 +0000 Snowgasm 786@http://www.wpwp.org/forums/ <p>Got the same problem on 3 blogs in total. </p> <p>ordPress Version: 2.7.1</p> <p>WordPress Host Server: Microsoft-IIS/6.0</p> <p>WordPress Time Offset: UTC 1.5 hours. (10:21 am)</p> <p>PHP Version: 5.2.6</p> <p>PHP Safe Mode : off</p> <p>PHP File Open Restrictions (open_basedir): off</p> <p>PHP Memory Allocation: 128M</p> <p>PHP Memory Usage: 17.22M</p> <p>PHP Script Timeout Limit: 120 seconds</p> <p>PHP Browser Capabilities File (browscap): browscap.ini</p> <p>PHP Curl: installed</p> <p>MySQL Version: 5.0.41-community-nt</p> <p>MySQL Engine: InnoDB</p> <p>MySQL Query Cache: 0 (disabled)</p> <p>MySQL Index (Key) Buffer: 174M</p> <p>MySQL Read Buffer: 0M</p> <p>MySQL Wait Timeout: 28800 seconds</p> <p>MySQL Char Set/Collation: utf8_general_ci</p> <p>MySQL Timezone: CEST (UTC 2)</p> <p>On all blogs there is no recording going on in wassup. Even a new blog does not allow recording. </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-785 Fri, 29 May 2009 04:38:13 +0000 SaW 785@http://www.wpwp.org/forums/ <p>didn't work :/</p> <p> setcookie("wassup", "$cookievalue", $expire, $cookiepath, $cookiedomain);<br /> this is the line 1814.<br /> should i try to comment out line 1814?<br /> like<br /> //setcookie("wassup", "$cookievalue", $expire, $cookiepath, $cookiedomain);<br /> this? </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-781 Thu, 28 May 2009 16:31:37 +0000 helene 781@http://www.wpwp.org/forums/ <p>Try going to Wassup-options=&gt;[Statistics Recording] Tab and disable "Record Akismet comment spam" (uncheck). </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-777 Thu, 28 May 2009 06:06:45 +0000 SaW 777@http://www.wpwp.org/forums/ <p>Thanks for your reply Michele..<br /> I tried to deactiveted my theme first. Then i activated wassup but i get the same error again.. Then i deacvtiveted all my plugins and i tried again but the result is same..<br /> I checked the wp-congig.php, it has not messed up.<br /> Any idea? </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-770 Mon, 25 May 2009 07:57:31 +0000 Michele 770@http://www.wpwp.org/forums/ <p>May be, SaW you could have a wp-config.php file messed up, or you have some white space around your plugins after the php closing tag (?&gt;) or before...<br /> Please chek these </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-760 Sat, 23 May 2009 16:42:31 +0000 helene 760@http://www.wpwp.org/forums/ <p>SaW,</p> <p>Your question is confusing as that error cannot occur unless Wassup's "wassupPrepend" function has been altered to print html/javascript output prior to writing Wassup's cookie or there is another plugin installed that prints output other than headers and cookies during Wordpress' "init" process (see Wordpress' <a href="http://codex.wordpress.org/Plugin_API/Action_Reference">Action reference codex doc</a> for information about the "init" hook).</p> <p>Please check your code and plugins. </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-757 Fri, 22 May 2009 15:57:29 +0000 SaW 757@http://www.wpwp.org/forums/ <p>Hello again..<br /> I have a blog on my site on a subdomain (blog.***.net)<br /> I am using a php code which is publishing the latest entries on my site www.***.net's homepage. The code would use the database.. I got an error when i activate the wassup 1.7.1</p> <p>Warning: Cannot modify header information - headers already sent by (output started at /home/*****/public_html/index.php:9) in /home/*****/public_html/blog/wp-content/plugins/wassup/wassup.php on line 1814</p> <p>How can i fix this?</p> <p>Thanks.. </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-756 Fri, 22 May 2009 12:41:15 +0000 helene 756@http://www.wpwp.org/forums/ <p>Poutnik,<br /> You are AWESOME! We will fix the "insert delayed" problem asap.<br /> ***</p> <p>C0d3r,<br /> Thanks for reporting the division by 0 error. It means that WassUp detailed queries to MySQL is getting no data back. Probably because of a syntax compatibility issue with your MySQL engine and version. I visited your blog (nice!) and Wassup seems to be recording visitor data. To diagnose why you can't see that data, I need to see your server settings in Wassup=&gt;Options=&gt;Manage Files&#38;Database to verify your MySQL engine's particular requirements.</p> <p>Also, while you are in "Manage Files&#38;Database", please note the number of records shown under "Table usage". Then after a few minutes have passed (or seconds, depending on your visitor count), reload the page and check the "Table usage" again. Let me know if the record count gets bigger. </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-754 Thu, 21 May 2009 19:56:21 +0000 c0d3r 754@http://www.wpwp.org/forums/ <p>I'm having the same issue with 1.7.1<br /> Even removing the DELAYED string from the statement in wassup.php did not solve the issue for me</p> <p>I did, however, see a warning in my php log :<br /> E_WARNING<br /> Division by zero at /data/www/blog/wp-content/plugins/wassup/wassup.php (1154) </p> <p>Any suggestions ? </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-752 Thu, 21 May 2009 10:08:46 +0000 poutnik 752@http://www.wpwp.org/forums/ <p>I have nailed down the problem to be caused by DELAYED transactions (inserts) into the wp_wassup database. Maybe a glitch in the configuration of my provider's SQL server. I have solved the problem by editing the wassup.php file and in the function insert_into_wp changing the line $delayed = "DELAYED" to $delayed = "";</p> <p>I'll look into the configuration of the SQL server.</p> <p>Jiri </p> http://www.wpwp.org/forums/topic/wassup-17-does-not-show-any-data#post-751 Thu, 21 May 2009 08:41:13 +0000 poutnik 751@http://www.wpwp.org/forums/ <p>Hello Helene,</p> <p>the settings is as follows:</p> <p>WordPress Version: 2.7.1<br /> WordPress Host Server: Apache/2.2.8 (Win32) PHP/5.2.5<br /> WordPress Time Offset: UTC 1 hod.. (08:13)<br /> PHP Version: 5.2.5<br /> PHP Memory Allocation: 32M<br /> PHP Memory Usage: 20.23M<br /> PHP Script Timeout Limit: 120 seconds<br /> PHP Browser Capabilities File (browscap): not set<br /> PHP Curl: installed<br /> MySQL Version: 5.0.51b-community-nt<br /> MySQL Engine: InnoDB<br /> MySQL Query Cache: 0 (disabled)<br /> MySQL Index (Key) Buffer: 84M<br /> MySQL Read Buffer: 0M<br /> MySQL Wait Timeout: 28800 seconds</p> <p>There are no errors in the source of the page to be seen, and the correct timestamp is correctly added to the bottom of the page.</p> <p>Only instead of the graph, I see: "Too few records to print chart...", and where there should be the data, there is nothing. If I look at the tables in MySQL database, wp_wassup_tmp table is populated correctly (entries are added, they look reasonable, old entries are deleted), but wp_wassup table is empty since the reinstall. (I even deleted both wp_wassup and _wassup_tmp tables and installed the plugin from scratch, to no avail).</p> <p>Thanks</p> <p>Jiri </p>