Add repair categories feature

[qazjayp]

My website is down out of the blue (blog version 1.2.2 )

Illegal operator and value combination.

Where('nest_left', '>=', null)

56 Illuminate\Database\Query\Builder->where(…)
55 call_user_func_array(…) ~/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php 526
54 Illuminate\Database\Eloquent\Builder->where(…) ~/vendor/october/rain/src/Database/Traits/NestedTree.php 357
53 RainLab\Blog\Models\Category->scopeAllChildren(…)

[daftspunk]

What database engine are you using? Did you upgrade anything at all?

[qazjayp]

mysql.

No nothing updated at all.

On 07/04/2016 11:05, Samuel Georges wrote:

What database engine are you using? Did you upgrade anything at all?

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub
http://email.sidekick.org/c/eJxFj71yhDAMhJ8GumNkS7JRQXEp8h7-Bc9xwGAo8vbxXIpottiv2B1tnHQYwfZlYgsGjaEBQQOB6QhqielVwmvYz7lfJstJXFKik2X0ZFxm5yIpQWsseezXabmuo3b47PR301yu5fZD2N8NTle21fnm_LrPj2O957I1KrXeqTajhDuNH2yJd9quhwZjhQShP6czHetPp78AMNvMiVGrRAgUI3JAMl6Us95AksDsSAyoMTKJDhn-TilUMSO0CU4ZCQlGHyxkaVs_9cP_x7_NWFGx

[daftspunk]

Try this php artisan tinker

Paste in

foreach (RainLab\Blog\Models\Category::whereNull('nest_left')->get() as $category) {
    $category->setDefaultLeftAndRight();
    $category->save();
}

[qazjayp]

I get this from Tinker

php artisan tinker
PHP Fatal error: Cannot use PhpParser\Node\Scalar\String as String
because 'String' is a special class name in
/home/forge/lifestyleproperty.co.uk/vendor/psy/psysh/src/Psy/CodeCleaner/MagicConstantsPass.php
on line 19

[Symfony\Component\Debug\Exception\FatalErrorException]
Cannot use PhpParser\Node\Scalar\String as String because
'String' is a special class name

On 07/04/2016 11:33, Samuel Georges wrote:

Try this |php artisan tinker|

Paste in

|foreach (RainLab\Blog\Models\Category::whereNull('nest_left')->get()
as $category) { $category->setDefaultLeftAndRight();
$category->save(); } |

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub
http://email.sidekick.org/c/eJxFjztyhTAMRVcD3WNk-auCIimyD8uWwfN4wPApsvt4aKJRcU8hzbl5xBTA93W0HpwmwEGDBwDfGThrlndN72E7pn4egw6YEUh0pkgIkrVFE4oTAwUg9cs4X9d-dvqrw5-2U73mm4e0fRocsa5L5JZ42abXvtxTXRvV87zlbEGR7VA_2C4-sl4vBBcAvXX9MR6yL78dfgPo4osV6wNzMyZFnqN1ZH0UUeAi21BM5siGnbGEqck9o5RWuZBjwqgcJYHAyUOh1vV5P_wb_wHRAFKC

[daftspunk]

Try putting it on a page with this PHP code

function onStart()
{
foreach (RainLab\Blog\Models\Category::whereNull('nest_left')->get() as $category) {
    $category->setDefaultLeftAndRight();
    $category->save();
}
}

Then open that page

[qazjayp]

This link: http://email.sidekick.org/c/eJwljjuOwzAQQ09jl8JIY_0KFZsAew99ZmLBXtiQlcK3XyEhWJEA-UpQ2YGda9AWDD6eRhjwYAGnBa5aaKt5E0d7zWvQmBOzWpyJhZkI9YKMiykcHWmy8x7W3s9rwp9J_Q7vlenq905nO05q_Rb5EO9tNH3kcwuNzv2e1AMA2bImrxMhDyCEbJ3TOsqcosukVIm-FGmk9YPNq8zwlZQoCyevvYrS-EzgUrbAfvB_5sWr9vWdxvXfP8swRw8

saved this:

function onStart() {

 echo 'called';

 $test = RainLab\Blog\Models\Category::whereNull('nest_left')->get();
 print_r($test->all());

 foreach 

(RainLab\Blog\Models\Category::whereNull('nest_left')->get() as $category) {
$category->setDefaultLeftAndRight();
$category->save();

 }

}

On 07/04/2016 11:42, Samuel Georges wrote:

Try putting it on a page with this PHP code

|function onStart() { foreach
(RainLab\Blog\Models\Category::whereNull('nest_left')->get() as
$category) { $category->setDefaultLeftAndRight(); $category->save(); } } |

Then open that page

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub
http://email.sidekick.org/c/eJxFj7uOhDAMRb8GukG2Qx4uKHZWmv9InASiYQDxKObvN6JZy8U9ha1z40DiwLZl0BaMev6azgCDBdX0cJSY3kXe3bqP7TRgBEIfuTd91hnA2AyS0ZqkoFeS2nmYznM7GvXT0KvuWM7pCp2snwq7L8vsQ01hXsfHNl9jWSqV47jSUQOybkjdWC8-aTkfBMaBJovtPuxpm78NPQFUtlkn1iGpXOUViHVOa48SvJNEFD3HiAYt1x5MUl3vQVQYc2DN5NGwJHBBLGSuXe_33b_xHyCUUrs

[daftspunk]

Looks like it's fixed now

We may need to include a "Repair categories" function because yours somehow became corrupted

[qazjayp]

How the hell is it working now?

Did the code you provide force a fix?

Somehow?

thanks

jon

On 07/04/2016 11:52, Samuel Georges wrote:

Looks like it's fixed now

We may need to include a "Repair categories" function because yours
somehow became corrupted

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub
http://email.sidekick.org/c/eJxFjztuxDAMRE9jd2tQpL6Fi02A3EOUKK-wXtvwp8jto2yKDFjMI8ABJ4-YPLi-jsaBpU9rBgUKNIROw1GzPGt6Dus-9Y-RgAFKSuSjZe2JmJzTzNbkzKrkfh4f57kdHd07_Goz1fNx8ZDWV4M91mWO3BzP63Tb5muqS6N6HJcczahgOqQ3touXLOcNwXoIaFW_j7ts83eHHwBUXDFSxEejhTQLGB3RR5HsrSJG9MVnNIF1Ni5gKvAnpUjlkkvbRWVDEvCcHJTfru_44f_jH5iGU5s

[daftspunk]

Yes of course it did =)

[qazjayp]

thanks again for you help

On 07/04/2016 11:55, Samuel Georges wrote:

Yes of course it did =)

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub
http://email.sidekick.org/c/eJxFj7mOg0AQRL8GMqM-5uqAYFcr_wdzwcgYEEewf--xN9hSBfWCLlXHnoID25ZeWzD8I_dOgQEBaRQcJaZHCY9u3cd26p22USVvgCASM7FVHDNZIGMF2bRzP53ndjT81dC9eizndPkurM8K-1CWefA1-Xkdb9t8jWWpVI7jSkcNKLoh_mC9eKblvBEYh3WObfd-T9v829A3AGebdQKVMEH2QiwhkCg_ZDcEnbzzGhVWqYiehUKGPyEyxpzECA1oJCRwPljI718_9d3_4hdxVFH4

[LukeTowers]

Closing as it has been over a month since any activity on this occurred.