http://www.wpwp.org/forums/tags/database WassUp Forums » Tag: database - Recent Posts en-US Thu, 09 Feb 2012 08:27:33 +0000 http://bbpress.org/?v=1.0.3 q http://www.wpwp.org/forums/search.php http://www.wpwp.org/forums/topic/registered-useres-are-not-recorded-correctly#post-1413 Wed, 08 Feb 2012 15:31:25 +0000 BaalOrun 1413@http://www.wpwp.org/forums/ <p>I cant figure out why the records are that different. The same user and ip is sometimes only recorded as visitor and sometimes as a registered user with the correct username shown.</p> <p>I looked it up in the database and wassup writes the username in the database but it is not shown everytime. Same system, same user, same ip, same browser, sometimes shown correctly sometimes not. </p> <p>Do you have any clou? </p> http://www.wpwp.org/forums/topic/wassup-not-recording#post-1317 Mon, 10 Oct 2011 14:41:48 +0000 Texiwill 1317@http://www.wpwp.org/forums/ <p>Solution was to disable plugin, remove db, and then reenable the plugin. Then all works. THankfully I backed up the database first. </p> http://www.wpwp.org/forums/topic/wassup-not-recording#post-1312 Sun, 09 Oct 2011 19:17:51 +0000 Texiwill 1312@http://www.wpwp.org/forums/ <p>Hello,</p> <p>I recently upgraded to 1.8.3, when I did this, recording stopped working. It looks like it is recording but data is only being placed into wassup_tmp and not the wassup table. The last entry in that table is from the day I did the upgrade.</p> <p>I thought perhaps it was something else, so I removed wassup, redownloaded and let it do its upgrade process and no go. It is still not recording data.</p> <p>Thoughts, help?</p> <p>Best regards,<br /> Edward </p> 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/database-errors#post-907 Wed, 14 Oct 2009 19:02:16 +0000 helene 907@http://www.wpwp.org/forums/ <p>Knutsp.<br /> What version of Wassup are you using? These issues were fixed in the latest releases of Wassup. Please upgrade to 1.7.2.1, if you have not aleady done so. </p> http://www.wpwp.org/forums/topic/database-errors#post-904 Tue, 13 Oct 2009 06:37:40 +0000 knutsp 904@http://www.wpwp.org/forums/ <p>"WordPress database error DELAYED option not supported for table 'wassup'" (I have InnoDB storage)</p> <p>"WordPress database error Incorrect integer value: '' for column 'searchpage' at row 1" (this row is declared as an integer)</p> <p>After deactivating, and then activating I get:</p> <p>"PHP Fatal error: Cannot redeclare wassup_install()" (it seems Wassup will not properly deactivate itself, had to delete plugin, all tables and reinstall) </p> http://www.wpwp.org/forums/topic/wassup-database-writing#post-574 Sat, 20 Sep 2008 12:48:11 +0000 ririzarry 574@http://www.wpwp.org/forums/ <p>Sounds great, Michele. Looking forward to hearing more. </p> http://www.wpwp.org/forums/topic/wassup-database-writing#post-556 Mon, 18 Aug 2008 08:55:55 +0000 Michele 556@http://www.wpwp.org/forums/ <p>We are just working to increase database performance, this could be one solution. Thank you. </p> http://www.wpwp.org/forums/topic/wassup-database-writing#post-552 Sat, 16 Aug 2008 03:07:50 +0000 ririzarry 552@http://www.wpwp.org/forums/ <p>I'd like to see a way for Wassup to delay its writes to the database in order to reduce its impact on the site. Firestats has a way to toggle this on right from its administrative interface and OWA demonstrates a manual process for doing this. </p> http://www.wpwp.org/forums/topic/using-wassup-with-another-database#post-274 Thu, 20 Mar 2008 18:29:30 +0000 Michele 274@http://www.wpwp.org/forums/ <p>Actually it's not possible to associate another database to WassUp, but I would like to implement this feature soon. </p> http://www.wpwp.org/forums/topic/using-wassup-with-another-database#post-273 Thu, 20 Mar 2008 13:08:27 +0000 arda9090 273@http://www.wpwp.org/forums/ <p>hello guys..</p> <p>I want to use WassUp plugin with another mysql database... Is ıt possible? Because Im getting 4000 hits everyday.. will it fill my mysql space?? </p> http://www.wpwp.org/forums/topic/alter-table-error-on-every-page-of-my-blog#post-81 Tue, 29 Jan 2008 14:17:21 +0000 geraldomagellajunior 81@http://www.wpwp.org/forums/ <p>That´s great! Keep up the great work! (When I grow up, I would like to be like you guys! :) LOL )<br /> Thank you, again, for your time, i'm very satisfied! </p> http://www.wpwp.org/forums/topic/alter-table-error-on-every-page-of-my-blog#post-80 Tue, 29 Jan 2008 14:10:40 +0000 Michele 80@http://www.wpwp.org/forums/ <p>I'm happy it works! Yes I gave you a modified version which will be the next release (1.4.4). </p> <p>Your WP tells you there is an upgrade because the version you are using now is 1.4.3a is different from the actual 1.4.3, please don't touch it before you see the 1.4.4 version available at <a href="http://wordpress.org/extend/plugins/wassup/" rel="nofollow">http://wordpress.org/extend/plugins/wassup/</a></p> <p>Thank you for the report </p> http://www.wpwp.org/forums/topic/alter-table-error-on-every-page-of-my-blog#post-79 Tue, 29 Jan 2008 12:20:52 +0000 geraldomagellajunior 79@http://www.wpwp.org/forums/ <p>Sorry, forgot to tell, my MySQL is version 4.1.18-nt.<br /> Thanks </p>