News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Enhanced User Statistics

Started by Rudolf, June 25, 2007, 11:51:34 AM

Previous topic - Next topic

TrueSatan

Upgrading your database is easy enough and shouldn't cause any problems though I'm not entirely convinced that that is the root of your problem here...anyhow...

I would very strongly advise that you upgrade to SMF 1.1.4.

There was no database upgrade in the general upgrade from SMF 1.1.3 to 1.1.4 so we have to go back to the upgrade pack for SMF 1.1.2 to 1.1.3 and in that use three files which should be uploaded to your forum root...I'll attach those files to this post.

Using your browser go to the upgrade.php file and that will cause it to run...expect a blank screen.

dxyy

Quote from: TrueSatan on November 21, 2007, 09:12:34 AM
Upgrading your database is easy enough and shouldn't cause any problems though I'm not entirely convinced that that is the root of your problem here...anyhow...

I would very strongly advise that you upgrade to SMF 1.1.4.

There was no database upgrade in the general upgrade from SMF 1.1.3 to 1.1.4 so we have to go back to the upgrade pack for SMF 1.1.2 to 1.1.3 and in that use three files which should be uploaded to your forum root...I'll attach those files to this post.

Using your browser go to the upgrade.php file and that will cause it to run...expect a blank screen.
Thank you, I'll upgrade the database soon.

If it's not a problem with the database, do you have any idea about what the real problem might be?

I'll eventually upgrade to 1.1.4, but I need to find someone to help me first, because I don't want any aspects of the forum to be non-functional. I have a bad feeling that some of the mods I have installed on my forum will need to be modified when I do upgrade...

Anyway, thank you for those files. :)

TrueSatan

I've answered your concerns re-upgrade on the Country Flags mod...and given a method that should do the job with no real problems.

Try the database upgrade and let's then see if your problem persists.

dxyy

Quote from: TrueSatan on November 21, 2007, 11:34:32 AM
I've answered your concerns re-upgrade on the Country Flags mod...and given a method that should do the job with no real problems.

Try the database upgrade and let's then see if your problem persists.
Where can I find the newest files for the database update?

I tried doing what you said, but I got the following message:
Quote
The upgrader found some old or outdated files.

Please make certain you uploaded the new versions of all the files included in the package.

Click here to try again.

Thanks for your help. :)

TrueSatan

The error you got tells me that your upgrade to SMF 1.1.3/4 wasn't done properly...you need to get the full upgrade done on all the files. Upgrading all the files does risk disrupting some of the mods you may have installed so doing a complete replacement of all your forum files save for the Attachments directory and Settings.php and Settings_bak.php in your forum root then reapplying all your mods and edits is one way round it and would give you an fresh forum with no left over issues from old installs. Alternatively doing the upgrade then fixing any non working mods would require manual editing of files whereas this would be less likely with a full replacement of the files and any editing would be merely what you must have done previously to install the mods.

You would get the necessary files by downloading the full installer for SMF 1.1.4, unpacking it and taking them from it.

With a lot of mods in place it is often easier to do a full replacement of the forum files then re-mod and re-edit rather than doing an upgrade.

dxyy

Thanks, I guess I'll have to try what you said.

I think it's weird that I did not get any error messages when I upgraded from 1.1.2 to 1.1.3, which was before I even had any mods installed. I also did not get any errors when I went from 1.1.3 to 1.1.4, but this time around I had 19 mods in place.

perplexed

#26
Quote from: kamili34 on July 04, 2007, 09:07:18 PM
Mod installed correct but when I want search in statistic I  got sth
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 m.posterTime <= 1173534646)' at line 2
Plik: /home/xxxxx/xxx/xxxxx_html/forum/Sources/Profile.php
Linia: 1734

Quote from: hugodiaz on November 21, 2007, 08:59:17 AM
I get the following error:

Quote
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 m.posterTime <= 1195534800)' at line 2
File: /home/daxueyin/public_html/finalforumtest/Sources/Profile.php
Line: 1877

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.3, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.

I have no idea how to update my database, so any help with that would be greatly appreciated.

I have this same error after just installing this mod on a test forum.  I selected a user, entered the dates from  2007 01 01  to  2007 05 05 as a test and I got the same error as above. Got this on any date range entered actually.

My forum and database are both up to date and don't need upgrading.  Can you tell me what is causing this error.  It shows up in the log as something similar:

QuoteDatabase Error: 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 m.posterTime <= 1178013600)' at line 2File: /home/mysite/public_html/testforum/Sources/Profile.phpLine: 1936

Line 1936 says:

WHERE ID_MEMBER = $memID AND (m.posterTime >= $start_date AND m.posterTime <= $end_date)",__FILE__,__LINE__);

Also the other option, where you select last/first no. of weeks/months etc doesn't work at all.  Regardless of what you select it returns the same results.


Thanks



Rudolf

All I can think of is that not all changes were applied to the Profile.php file.
Can you attach it here?
I will update all my mods in the next few weeks. Thanks for your patience.

SVG-Collapse (you need an SVG compliant browser)

rakael

Hi, i got this error when try to generate some user statistic

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 m.posterTime <= 1271818800)' at line 2
File: /home/audiobfo/public_html/community/Sources/Profile.php
Line: 1800

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.



Can some one help me?

_sebas_


hi !

I have this error:

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 m.posterTime <= 1230822000)' at line 2

Archivo: /home/content/s/e/b/sebtor/html/foro/Sources/Profile.php
Línea: 1838

Nota: Parece que tu base de datos puede necesitar una actualización.
La versión de los archivos de tu foro están en la versión SMF 1.1.12,
mientras que tu base de datos está en la versión de SMF 1.1.4.
Te recomendamos que ejecutes la última versi&oacuten de upgrade.php.


any idea ???

Rudolf

What version of SMF you have, and please post the lines around the line  1838 in your Profile.php file (+/- 10 lines should be enough).
I will update all my mods in the next few weeks. Thanks for your patience.

SVG-Collapse (you need an SVG compliant browser)

khudher

Please provide support for last version of smf (2.0.8)
:) :) :)
Hope you will reply soon!

Advertisement: