WWD

Unfortunately the issue still persists. It says there's a syntax error... how could this be?

Yes:

Hi, Every time I search something on my board with three letters in each word or less it throws an error SELECT main.* FROM `IPScore_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\forums\Topic\Post' OR index_class='IPS\form\Log' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) ) AND AND ( index_permissions = '*' OR ( FIND_IN_SET(4,index_permissions) OR FIND_IN_SET(13,index_permissions) OR FIND_IN_SET('m565',index_permissions) ) ) ORDER BY index_date_created DESC LIMIT 0,25 IPS\Db\Exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND ( index_permissions = '*' OR ( FIND_IN_SET(4,index_permissions) OR FIND_IN_S' at line 1 (1064) #0 /var/www/html/system/Db/Select.php(378): IPS\_Db->preparedQuery('/*IPS\\Content\\S...', Array, true) #1 /var/www/html/system/Db/Select.php(440): IPS\Db\_Select->runQuery() #2 [internal function]: IPS\Db\_Select->rewind() #3 /var/www/html/system/Content/Search/Mysql/Query.php(1258): iterator_to_array(Object(IPS\Db\Select)) #4 /var/www/html/applications/core/modules/front/search/search.php(608): IPS\Content\Search\Mysql\_Query->search('ok go', NULL, 17) #5 /var/www/html/applications/core/modules/front/search/search.php(73): IPS\core\modules\front\search\_search->_results() #6 /var/www/html/system/Dispatcher/Controller.php(96): IPS\core\modules\front\search\_search->manage() #7 /var/www/html/system/Dispatcher/Dispatcher.php(146): IPS\Dispatcher\_Controller->execute() #8 /var/www/html/index.php(12): IPS\_Dispatcher->run() #9 {main} Here is a visual example of what happens: Things I have done to fix the problem: Repaired database tables Cleared cache Rebuild search index I am stumped as to what is going on. I also have this same exact error on a test board I created with a separate database. Thanks!

too Wow, this is depressing. WEBFLAKE MEMBERS WHERE YA'LL AT WE GETTIN' REKT OVER HERE!

Thanks for rubbing it in! Just kidding, I envy you and your experience haha.

This is the shortcoming of the Announcements feature - when you put a widget with announcements that have links, they will not be hyperlinked, and for no apparent reason. This is why I do not use announcements on my community Alternatively, you could just create a custom block via the Portal app and put that block wherever you want!

Java and the basics of JS/PHP/HTML/CSS. Nothing fancy, mind you.

Juan Staff members following this = cheating

Lol, he knows that @Cookie Monster probably has the answer

Hi, I originally posted in the #support on the Discord server; @Cookie Monster directed me to post here for a closer look. I turned on IPS's Image Proxy in an attempt to move my site to full HTTPS, getting rid of insecure images. However, the Topic Thumbnails, when fetching the image from the topic, is not fetching it correctly: As you can see, it's not recognizing the "Base URL", which should be my domain: /applications/core/interface/imageproxy/imageproxy.php?img=http://is5.mzstatic.com/image/thumb/Music128/v4/a0/81/78/a08178ef-49b4-4065-18d0-2b32923c4a8a/source/600x600bb.jpg&key=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx. For my purposes, it would just be easier to get rid of the part of it in the first place as it would still correctly embed using <img src="">. Can anyone help me modify the plugin code to do this? Here is the code for Topic Thumbnails 1.1.4 for 4.x that I downloaded from WF: https://pastebin.com/vJRgtrDy (I found using CTRL + F "base_url" on line 108 but I don't know if it's significant or what to do with it) Thanks! WWD

@Codeeco Try purging your cache in cloudflare or temporarily "unpass" Cloudflare's CDN from your board (make the orange cloud in DNS gray). Then clear your own browser's cache, your board's cache (Support > "Something isn't working correctly" > Next), and try again. If it still happens then it's most likely not an issue with CF and will give a more clear indication of what the issue is.

@Davlin @Cookie Monster I've successfully upgraded to 4.2.5! For anyone who has this same issue, your issue is with the group that owns the files in the document root. Thank you for helping me pinpoint the problem. I will most certainly be donating within the next few days Here's roughly how I fixed it: (CentOS 7 running NGINX and php-fpm) -Created user group www-data -Created user www-data and added to group www-data -added nginx and php-fpm to www-data: usermod -aG www-data nginx usermod -aG www-data php-fpm -edit configuration files of nginx and php-fpm vi /etc/php-fpm.d/www.conf user = www-data; group = www-data; ... listen.owner = www-data listen.group = www-data vi /etc/nginx/nginx.conf user www-data; -recursively made www-data user and group owner of document root chown -R www-data:www-data /var/www/html -made www-data owner of php lib and nginx chown -R www-data:www-data /var/lib/php chown -R www-data:www-data /var/lib/nginx -restarted NGINX and php-fpm service nginx restart service php-fpm restart This can be resolved, thanks!

Clean install works fine, no issues. I am using not using a CDN. However, I did some research - does it sound right that the issue may be that php-fpm and NGINX are not in the group that owns the web root? Perhaps php-fpm cannot write because it does not own the document root...However, that does not explain why a clean install works perfectly fine in a subdirectory... Here is the most recent error log - as you can see there's nothing related to "COULD_NOT_WRITE_FILE" because I couldn't even finish the upgrade to start with:

Okay, I am doing a test upgrade (I copied my board and database to a sub-directory and updated my conf_global.php to match that subdirectory). I am now running into an old friend that was the error I could never fix: Yes, I have tried CHMOD 777 (and 757). Both to no avail. Here is FileSystem.php::326 for reference: /* Save the file */ if( $this->temporaryFilePath ) { if( !@\rename( $this->temporaryFilePath, "{$folder}/{$this->filename}" ) ) { \IPS\Log::log( "Could not move file {$folder}/{$this->filename}" , 'FileSystem' ); throw new \RuntimeException( 'COULD_NOT_MOVE_FILE' ); } @chmod( "{$folder}/{$this->filename}", \IPS\IPS_FILE_PERMISSION ); } else { if ( $contents = $this->contents() ) { if ( !@\file_put_contents( "{$folder}/{$this->filename}", $contents ) ) { \IPS\Log::log( "Could not write file {$folder}/{$this->filename}" , 'FileSystem' ); throw new \RuntimeException( 'COULD_NOT_WRITE_FILE' ); #**********THIS IS LINE 326************** } @chmod( "{$folder}/{$this->filename}", \IPS\IPS_FILE_PERMISSION ); } else { $return = touch( "{$folder}/{$this->filename}" ); @chmod( "{$folder}/{$this->filename}", \IPS\IPS_FILE_PERMISSION ); } }

PM'd my host to you on WF

Thank you for such a timely reply! Fortunately I restored my old backup (thus no more error logs), but here is the error I have been seeing the most often: RuntimeException: COULD_NOT_WRITE_FILE (0) #0 /var/www/html/system/File/File.php(239): IPS\File\_FileSystem->save() #1 /var/www/html/system/Theme/Theme.php(4843): IPS\_File::create('core_Theme', '3ba4fd28c064b4f...', ' .ipsApp_admin ...', 'css_built_1') #2 /var/www/html/system/Theme/Theme.php(2350): IPS\_Theme::writeCss(Array) #3 /var/www/html/system/Theme/Theme.php(558): IPS\_Theme->compileCss('core', 'admin', 'core', 'core.css') #4 /var/www/html/system/Dispatcher/Admin.php(97): IPS\_Theme->css('core.css', 'core', 'admin') #5 /var/www/html/system/Dispatcher/Dispatcher.php(86): IPS\Dispatcher\_Admin->init() #6 /var/www/html/admin/index.php(13): IPS\_Dispatcher::i() #7 {main} All the folders were correctly chmodded... I am going to try a test install of WF 4.2.5 in a sub-directory and will get back to you as soon as possible with any issues! Thanks, Andy

I am currently in a situation with a terrible nulled/licensed version of IPS and I don't know how to get out of it. I want to switch over to WebFlake's offer of IPS 4.2 because every attempt I have made to upgrade from 4.1.7 to 4.2 (even 4.1.7 to 4.1.8) with IV has ended in a completely broken site with "COULD_NOT_WRITE_FILE" errors for every link, even though I had CHMODded all the folders to their correct permissions. I want to be as helpful as possible, so just to get a sense of the troubles I have had recently, here is how my site ended up: As a consequence, I am stuck on 4.1.7.1 with no hope and no help from staff at IV. I had given them my FTP login to do the upgrade to 4.2 and they completely trashed my site, rendering it useless. Reading @Davlin's inspirational post a few weeks ago has prompted me to reach out for help from the WF community... I have found myself utterly unable to turn to anyone for help at IV. I am essentially running a dead site now...with very limited capacity to install new features and applications. I look in the Servers forum here and am astonished to see how many people at WF are well-versed in hosting websites and working with a VPS. That in itself makes me want to become more active around here. But I cannot do that while in the chains of IV... Is there anyone who can help me with my situation? Thanks for all you do, Andy

Been looking around for this...Thanks!

@silentbr are you running IPS 4.1? This is for 4.1 support only. The reason I am asking is because IPS 4 has a lot more compatibility with editing themes.