Recent Posts

1

Theme Support / Re: How can i change stars and change admin to Forum owner feks

« Last post by JanicBrocs on April 08, 2019, 03:25:54 am »

Das Wichtigste, was ich verstehe, ist, dass diese Website eine sehr kenntnisreiche Website ist, in der sehr viel Informationen ausgetauscht werden kann.

2

General Support / Re: DATABASE ERROR !!ads management mod !!

« Last post by JanicBrocs on April 08, 2019, 03:25:44 am »

Ich weiß, dass diese Site eine große Site zum Datenaustausch ist, also habe ich mehr Informationen recherchiert, um sie mit Menschen außerhalb zu teilen.

3

Bugs / Re: Database error after upgrading to Mysql 5.7

« Last post by melktert on April 06, 2019, 10:03:34 am »

Thank you
I've made the change. I did upgrade to latest version but appears it didn't update the database.

Thanks again for your help

4

Bugs / Re: Database error after upgrading to Mysql 5.7

« Last post by vbgamer45 on April 06, 2019, 10:00:16 am »

bigint i believe that's what I used in the latest version.

5

Bugs / Re: Database error after upgrading to Mysql 5.7

« Last post by melktert on April 06, 2019, 09:58:53 am »

Thanks

I changed the hits value to 1 and that took the error away.

What datatype do you suggest?

6

Bugs / Re: Database error after upgrading to Mysql 5.7

« Last post by vbgamer45 on April 06, 2019, 09:53:05 am »

You have to increase the hits column in the ads table to a larger integer datatype.

7

Bugs / Database error after upgrading to Mysql 5.7

« Last post by melktert on April 06, 2019, 09:51:18 am »

Hi

I'm getting the following errors in my log since upgrading to Mysql 5.7:

Database Error: Out of range value for column 'HITS' at row 1Apply
Filter: Only show the errors from this file File: /home/brokenwiener/public_html/forums/Sources/LoadAds.php
Line: 298

Forum displays this at the bottom:
Out of range value for column 'HITS' at row 1
File: /home/brokenwiener/public_html/forums/Sources/LoadAds.php
Line: 298

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

Error 298 refers to:

Code: [Select]

$smcFunc['db_query']('',"UPDATE {db_prefix}ads SET hits = hits+1 WHERE ADS_ID = $id"); in LoadAds.php

Version Information:
Forum version: SMF 2.0.15 (more detailed)
Current SMF version: SMF 2.0.15
GD version: bundled (2.1.0 compatible)
Database Server: MySQL
MySQL version: 5.7.25-log
PHP: 5.6.40
Server version: Apache/2.4.39 (cPanel) OpenSSL/1.0.2r mod_bwlimited/1.4

Any ideas how to clear this?

8

General Support / Re: Removal of 'SMFAds for Free Forums'

« Last post by vbgamer45 on March 04, 2019, 01:44:39 pm »

You can upload the mod to https://www.smfhacks.com/smf-package-parser.html
And get the manual uninstall instructions.

9

General Support / Re: Removal of 'SMFAds for Free Forums'

« Last post by koyinpyone on March 04, 2019, 01:43:09 pm »

How can I uninstall ads mod from my forum? I installed that mod since 2014 and don't have that package in my package manager.
we got a problem on reply page and that always redirect to http://tectonny.com/?redir=frame&uid=tectonny5c7b073c869ed8.89833521
thanks,

10

Ad Support / Re: AdManagment shows error on add ads

« Last post by vbgamer45 on February 27, 2019, 08:21:31 am »

I would check with your host. SOmetimes .htaccess is not enough