Tyler

In addition to my last post noting an SQL error with the donation application: I have come to realize that I do not have global permissions with my current host. This means that I need to change the formatting of the SQL command when ordering the donations using "ORDER BY". However, I cannot seem to find where I can change this SQL query. Can someone please suggest where to look?

I am currently getting the following log whenever a user tries to use the donation system: SELECT *, SUM(amount) AS total_amount FROM `donate_users` WHERE status=1 AND anon=0 AND date>1491969600 GROUP BY `member_id` ORDER BY total_amount DESC LIMIT 5 IPS\Db\Exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'webcom_ips.donate_users.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055) #0 /usr/www/webcom/public/system/Db/Select.php(378): IPS\_Db->preparedQuery('/*IPS\\donate\\wi...', Array, true) #1 /usr/www/webcom/public/system/Db/Select.php(440): IPS\Db\_Select->runQuery() #2 /usr/www/webcom/public/applications/donate/widgets/donateDonations.php(130): IPS\Db\_Select->rewind() #3 /usr/www/webcom/public/system/Widget/Widget.php(797): IPS\donate\widgets\_donateDonations->render() #4 /usr/www/webcom/public/system/Theme/Theme.php(824) : eval()'d code(17385): IPS\_Widget->__toString() #5 /usr/www/webcom/public/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->widgetContainer('sidebar', 'vertical') #6 /usr/www/webcom/public/system/Theme/Theme.php(824) : eval()'d code(15022): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array) #7 /usr/www/webcom/public/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->sidebar('right') #8 /usr/www/webcom/public/system/Theme/Theme.php(824) : eval()'d code(6230): IPS\Theme\_SandboxedTemplate->__call('sidebar', Array) #9 /usr/www/webcom/public/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->globalTemplate('25161dcbab12e64...', '\n\n\n<div class='...', Array) #10 /usr/www/webcom/public/system/Dispatcher/Dispatcher.php(166): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #11 /usr/www/webcom/public/system/Dispatcher/Standard.php(118): IPS\_Dispatcher->finish() #12 /usr/www/webcom/public/system/Dispatcher/Front.php(574): IPS\Dispatcher\_Standard->finish() #13 /usr/www/webcom/public/system/Dispatcher/Dispatcher.php(148): IPS\Dispatcher\_Front->finish() #14 /usr/www/webcom/public/index.php(13): IPS\_Dispatcher->run() #15 {main} Any Ideas? Edit: Additionally, I have tried to run the query SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); But this appears to have no effect on the error.

AMD for budget builds. But Intel for higher end stuff

I use spotify! With the student discount, its only like $5 a month

Hi there, I was wondering if anyone here can change the red theme in this image to blue. I still want the detail to be there so please do not waste your time using a paint bucket to make everything blue. Thanks in advance

^^ this.

Why would you get domain names?

Que the spammers.

Thanks for all the help!

Hello everyone, as the title states I would like to know how to remove the index.php? from the domains on my forums. I see other threads with the same idea but the difference I have is that my forums are located on the root of my server "/public/" Any help is much appreciated! <3

Does anyone have some time to do this?

That would be greatly appreciated, sir Anyone have the time to do this? I can offer some $ if necessary

Howdy, I'm looking for a new logo for my gaming community, NovaHQ http://novahq.org I'm hoping to have it include the following Color Scheme - Blue/aqua and white/black Font type - Whatever you wish Images - Something to do with "Nova" - A shining star or something related. Community type - Gaming Logo size - At least 400x400 Text desired - NovaHQ or NHQ Slogan - Gamers, welcome home. - You do NOT NEED to include this if you do not wish to do so I'm hoping to have a logo with this sort of design http://www.deviantart.com/art/Team-CoolerMaster-Logo-126474889 Obviously not the colour scheme, but something that mixes well with all elements. Thanks! -Tyler

They just haven't been caught yet..

In order to use adsense, you must agree to their terms. Fully read the terms and agreements to ensure you are not doing anything you are not suppose to be doing. Keep in mind having a nulled or retail website (which is illegal) is against their rules.