Deprecated: Method ReflectionProperty::setAccessible() is deprecated since 8.5, as it has no effect since PHP 8.1 in /var/www/html/plugins/system/falangdriver/falangdriver.php on line 534
Joomla 5.x 工作流调试脚本 - Bluetooth forum - bluetooth蓝牙技术

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/components/com_comprofiler/plugin/user/plug_cbjdownloads/cbjdownloads.php on line 49

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php on line 48

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php on line 47

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 217

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 219

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 227

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 231

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 234

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
Technical discuss

Joomla 5.x 工作流调试脚本


Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

Deprecated: Using null as the key parameter for array_key_exists() is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/cbPluginHandler.php on line 323

  • Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
    service
  • [
    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
    service]

  • Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
    帖子作者

  • Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

    Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
    离线
  • 管理员
  • 管理员
更多
2026-01-12 03:33 #1009
Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239
by service
新帖
命令行运行生成一个文件
Code:
# 创建调试脚本 cat > "debug_Joomla5x_workflow.php" << 'EOF' <?php /**  * Joomla 5.x 工作流调试脚本  * 直接运行此脚本检查工作流配置  */ define('_JEXEC', 1); define('JPATH_BASE', dirname(__DIR__)); // Joomla根目录 require_once JPATH_BASE . '/includes/defines.php'; require_once JPATH_BASE . '/includes/framework.php'; // 初始化Joomla $app = JFactory::getApplication('site'); // 检查Joomla版本 echo "<h1>Joomla 版本: " . JVERSION . "</h1>\n"; // 检查工作流表 $db = JFactory::getDbo(); $tables = [     '#__workflows',     '#__workflow_stages',      '#__workflow_transitions',     '#__assets',     '#__content' ]; echo "<h2>数据库表检查</h2>\n"; echo "<table border='1' cellpadding='5'>\n"; echo "<tr><th>表名</th><th>状态</th><th>记录数</th></tr>\n"; foreach ($tables as $table) {     try {         // 检查表是否存在         $db->setQuery("SHOW TABLES LIKE '" . str_replace('#__', $db->getPrefix(), $table) . "'");         $exists = $db->loadResult();                  if ($exists) {             // 获取记录数             $db->setQuery("SELECT COUNT(*) FROM " . $table);             $count = $db->loadResult();             echo "<tr><td>{$table}</td><td style='color:green'>✓ 存在</td><td>{$count}</td></tr>\n";                          // 如果是workflows表,显示内容             if ($table === '#__workflows') {                 $db->setQuery("SELECT * FROM " . $table . " LIMIT 5");                 $workflows = $db->loadObjectList();                 if ($workflows) {                     echo "<tr><td colspan='3'>";                     foreach ($workflows as $wf) {                         echo "ID: {$wf->id}, 标题: {$wf->title}, 状态: {$wf->published}<br>\n";                     }                     echo "</td></tr>\n";                 }             }                          // 如果是workflow_stages表,显示内容             if ($table === '#__workflow_stages') {                 $db->setQuery("SELECT * FROM " . $table . " WHERE workflow_id = 1");                 $stages = $db->loadObjectList();                 if ($stages) {                     echo "<tr><td colspan='3'>";                     foreach ($stages as $stage) {                         echo "阶段ID: {$stage->id}, 标题: {$stage->title}, 工作流: {$stage->workflow_id}<br>\n";                     }                     echo "</td></tr>\n";                 }             }         } else {             echo "<tr><td>{$table}</td><td style='color:red'>✗ 不存在</td><td>-</td></tr>\n";         }     } catch (Exception $e) {         echo "<tr><td>{$table}</td><td style='color:orange'>⚠ 错误: " . $e->getMessage() . "</td><td>-</td></tr>\n";     } } echo "</table>\n"; // 检查最近创建的文章 echo "<h2>最近通过API创建的文章</h2>\n"; $query = $db->getQuery(true)     ->select('*')     ->from('#__content')     ->where('created_by_alias = ' . $db->quote('AI助手'))     ->order('id DESC')     ->setLimit(10); $db->setQuery($query); $articles = $db->loadObjectList(); echo "<table border='1' cellpadding='5'>\n"; echo "<tr>     <th>ID</th>     <th>标题</th>     <th>状态</th>     <th>asset_id</th>     <th>workflow_id</th>     <th>stage_id</th>     <th>创建时间</th> </tr>\n"; foreach ($articles as $article) {     $statusColor = $article->state == 1 ? 'green' : ($article->state == 0 ? 'red' : 'orange');     echo "<tr>         <td>{$article->id}</td>         <td>{$article->title}</td>         <td style='color:{$statusColor}'>{$article->state}</td>         <td>{$article->asset_id}</td>         <td>" . ($article->workflow_id ?? 'NULL') . "</td>         <td>" . ($article->stage_id ?? 'NULL') . "</td>         <td>{$article->created}</td>     </tr>\n"; } echo "</table>\n"; // 检查asset表对应的记录 echo "<h2>文章对应的Asset记录</h2>\n"; foreach ($articles as $article) {     if ($article->asset_id) {         $query = $db->getQuery(true)             ->select('*')             ->from('#__assets')             ->where('id = ' . (int)$article->asset_id);         $db->setQuery($query);         $asset = $db->loadObject();                  if ($asset) {             echo "<h3>文章 ID: {$article->id} - Asset ID: {$article->asset_id}</h3>\n";             echo "<pre>";             print_r($asset);             echo "</pre>\n";         } else {             echo "<p style='color:red'>文章 ID: {$article->id} 的asset记录不存在!</p>\n";         }     } } // 尝试创建一个测试文章 echo "<h2>创建测试文章</h2>\n"; try {     // 使用Joomla Table类     JTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_content/tables');     $table = JTable::getInstance('Content', 'ContentTable');          $testData = [         'title' => '工作流测试文章 ' . date('Y-m-d H:i:s'),         'alias' => 'workflow-test-' . time(),         'introtext' => '这是工作流测试文章的内容',         'fulltext' => '',         'catid' => 2,         'state' => 1,         'language' => '*',         'created' => JFactory::getDate()->toSql(),         'created_by' => JFactory::getUser()->id,         'created_by_alias' => '工作流测试',         'publish_up' => JFactory::getDate()->toSql(),         'access' => 1,         'workflow_id' => 1,         'stage_id' => 1,         'metadata' => '{"robots":"","author":"","rights":"","xreference":""}'     ];          if ($table->bind($testData) && $table->check() && $table->store()) {         echo "<p style='color:green'>✓ 测试文章创建成功!ID: {$table->id}</p>\n";                  // 检查创建的记录         $query = $db->getQuery(true)             ->select('*')             ->from('#__content')             ->where('id = ' . (int)$table->id);         $db->setQuery($query);         $createdArticle = $db->loadObject();                  echo "<h3>创建的文章详情:</h3>\n";         echo "<pre>";         print_r($createdArticle);         echo "</pre>\n";                  // 检查asset         if ($createdArticle->asset_id) {             $query = $db->getQuery(true)                 ->select('*')                 ->from('#__assets')                 ->where('id = ' . (int)$createdArticle->asset_id);             $db->setQuery($query);             $createdAsset = $db->loadObject();                          echo "<h3>对应的Asset记录:</h3>\n";             echo "<pre>";             print_r($createdAsset);             echo "</pre>\n";         }     } else {         echo "<p style='color:red'>✗ 测试文章创建失败: " . $table->getError() . "</p>\n";     } } catch (Exception $e) {     echo "<p style='color:red'>✗ 测试文章创建异常: " . $e->getMessage() . "</p>\n";     echo "<pre>" . $e->getTraceAsString() . "</pre>\n"; } echo "<hr>\n"; echo "<p>调试完成。</p>\n"; EOF echo "" echo "📁 创建了调试脚本: debug_workflow.php" echo "" echo "🔍 使用方法:" echo "  1. 将此文件上传到Joomla根目录" echo "  2. 通过浏览器访问: https://xxx.com/debug_workflow.php" echo "  3. 查看详细的工作流和数据库状态" echo "" echo "🎯 这个版本应该能彻底解决Joomla 5.x的工作流问题!" echo ""

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 234

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 189

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 237

Deprecated: Using null as an array offset is deprecated, use an empty string instead in /var/www/html/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php on line 239

登录注册一个帐号 参加讨论

核心: Kunena 论坛
FaLang translation system by Faboba

Deprecated: Method ReflectionProperty::setAccessible() is deprecated since 8.5, as it has no effect since PHP 8.1 in /var/www/html/plugins/system/falangdriver/falangdriver.php on line 100

Deprecated: Method ReflectionProperty::setAccessible() is deprecated since 8.5, as it has no effect since PHP 8.1 in /var/www/html/plugins/system/falangdriver/falangdriver.php on line 100
mysqli object is already closed (500 Whoops, looks like something went wrong.)

Error

HTTP 500 Whoops, looks like something went wrong.

mysqli object is already closed

Exception

Error

  1. */
  2. public function disconnect()
  3. {
  4. // Close the connection.
  5. if (\is_callable([$this->connection, 'close'])) {
  6. $this->connection->close();
  7. }
  8. parent::disconnect();
  9. }
  1. */
  2. public function disconnect()
  3. {
  4. // Close the connection.
  5. if (\is_callable([$this->connection, 'close'])) {
  6. $this->connection->close();
  7. }
  8. parent::disconnect();
  9. }
  1. *
  2. * @since 2.0.0
  3. */
  4. public function __destruct()
  5. {
  6. $this->disconnect();
  7. }
  8. /**
  9. * Alter database's character set.
  10. *
DatabaseDriver->__destruct()

Stack Trace

Error
Error:
mysqli object is already closed

  at /var/www/html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:318
  at mysqli->close()
     (/var/www/html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:318)
  at Joomla\Database\Mysqli\MysqliDriver->disconnect()
     (/var/www/html/libraries/vendor/joomla/database/src/DatabaseDriver.php:496)
  at Joomla\Database\DatabaseDriver->__destruct()                

Deprecated: Method ReflectionProperty::setAccessible() is deprecated since 8.5, as it has no effect since PHP 8.1 in /var/www/html/plugins/system/falangdriver/falangdriver.php on line 100

Deprecated: Method ReflectionProperty::setAccessible() is deprecated since 8.5, as it has no effect since PHP 8.1 in /var/www/html/plugins/system/falangdriver/falangdriver.php on line 100