New company, install plugin Domain Manager, but not installed correctly

[Education]

I have Addon Companies license

I just install blesta again fresh, the latest version (5.10.1), and not changing anything yet, just add a company & httpd.conf in Directadmin

Then under that new company, try installing a plugin : Domain Manager, but always get below error message & no Domains Options in Packages drop down.
Looks like only related to Blesta, not related to Directadmin

 

Quote

Something went wrong.
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'registration_date'.
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'registration_date' on line 196 in /home/theusername/domains/thedomain.com/public_html/vendors/minphp/db/src/PdoConnection.php
PDOStatement->execute Line 196

/home/theusername/domains/thedomain.com/public_html/vendors/minphp/db/src/PdoConnection.php
Minphp\Db\PdoConnection->query Line 634

/home/theusername/domains/thedomain.com/public_html/plugins/domains/domains_plugin.php
DomainsPlugin->upgrade1_12_0 Line 146

/home/theusername/domains/thedomain.com/public_html/plugins/domains/domains_plugin.php
DomainsPlugin->install Line 251

/home/theusername/domains/thedomain.com/public_html/app/models/plugin_manager.php
PluginManager->add Line 570

/home/theusername/domains/thedomain.com/public_html/app/controllers/admin_company_plugins.php
AdminCompanyPlugins->install Line 142

/home/theusername/domains/thedomain.com/public_html/vendors/minphp/bridge/src/Lib/Dispatcher.php
Dispatcher::dispatch Line 21

/home/theusername/domains/thedomain.com/public_html/index.php
140

    public function setFetchMode($fetchMode)

141

    {

142

        $cur = $this->fetchMode;

143

        $this->fetchMode = $fetchMode;

144

        return $cur;

145

    }

146

 

147

    /**

148

     * Get the last inserted ID

149

     *

150

     * @param string $name The name of the sequence object from which the ID should be returned

151

     * @return string The last ID inserted, if available

152

     */

153

    public function lastInsertId($name = null)

154

    {

155

        return $this->connect()->lastInsertId($name);

156

    }

157

 

158

    /**

159

     * Sets the given value to the given attribute for this connection

160

     *

161

     * @param long $attribute The attribute to set

162

     * @param int $value The value to assign to the attribute

163

     * @return PdoConnection

164

     */

165

    public function setAttribute($attribute, $value)

166

    {

167

        $this->connect()->setAttribute($attribute, $value);

168

        return $this;

169

    }

170

 

171

    /**

172

     * Query the Database using the given prepared statement and argument list

173

     *

174

     * @param string $sql The SQL to execute

175

     * @param string $... Bound parameters [$param1, $param2, ..., $paramN]

176

     * @return PDOStatement The resulting PDOStatement from the execution of this query

177

     */

178

    public function query($sql)

179

    {

180

        $params = func_get_args();

181

        // Shift the SQL parameter off of the list

182

        array_shift($params);

183

 

184

        // If 2nd param is an array, use it as the series of params, rather than

185

        // the rest of the param list

186

        if (isset($params[0]) && is_array($params[0])) {

187

            $params = $params[0];

188

        }

189

 

190

        $this->connect();

191

 

192

        // Store this statement in our PDO object for easy use later

193

        $this->statement = $this->prepare($sql, $this->fetchMode);

194

 

195

        // Execute the query

196

        $this->statement->execute($params);

197

 

198

        // Return the statement

199

        return $this->statement;

200

    }

201

 

202

    /**

203

     * Prepares an SQL statement to be executed by the PDOStatement::execute() method.

204

     * Useful when executing the same query with different bound parameters.

205

     *

206

     * @param string $sql The SQL statement to prepare

207

     * @param int $fetchMode The PDO::FETCH_* constant

208

     * @return PDOStatement The resulting PDOStatement from the preparation of this query

209

     * @see PDOStatement::execute()

210

     */

211

    public function prepare($sql, $fetchMode = null)

212

    {

213

        if ($fetchMode === null) {

214

            $fetchMode = $this->fetchMode;

215

        }

216

 

217

        $this->statement = $this->connect()->prepare($sql);

218

        // Set the default fetch mode for this query

219

        $this->statement->setFetchMode($fetchMode);

220

 

221

        return $this->statement;

222

    }

223

 

224

    /**

225

     * Begin a transaction

226

     *

227

     * @return boolean True if the transaction was successfully opened, false otherwise

228

     */

229

    public function begin()

230

    {

231

        return $this->connect()->beginTransaction();

232

    }

233

 

234

    /**

235

     * Rolls back and closes the transaction

236

     *

237

     * @return boolean True if the transaction was successfully rolled back and closed, false otherwise

238

     */

239

    public function rollBack()

240

    {

241

        return $this->connect()->rollBack();

242

    }

243

 

244

    /**

245

     * Commits a transaction

246

     *

247

     * @return boolean True if the transaction was successfully commited and closed, false otherwise

248

     */

249

    public function commit()

250

    {

251

        return $this->connect()->commit();

252

    }

 

 

 

 

Please give hot fix,
or pm if you want to try it live. Its ok to making changes, i am planning to install the Blesta again later fresh

Waiting your answer

 

 

[Paul]

Looks like a bug, I've created the following task:

https://dev.blesta.com/browse/CORE-5237

If you are not selling domains on the other company, you can uninstall the plugin. Then you should be able to install it on the other company. This one may be fairly complex to resolve.

[Education]

Didnt anyone have Addon Companies & have this problem too with latest version (5.10.1)?

 

I tried this simple hot fix works :

open blesta\plugins\domains\domains_plugin.php
find all : registration_date
replace all with : registration_date2

 

Install plugin Domain Manager again as another company

 

 

But better waiting for official hot fix

[Paul]

15 minutes ago, Education said:

Didnt anyone have Addon Companies & have this problem too with latest version (5.10.1)?

 

I tried this simple hot fix works :

open blesta\plugins\domains\domains_plugin.php
find all : registration_date
replace all with : registration_date2

 

Install plugin Domain Manager again as another company

 

 

But better waiting for official hot fix

That will likely cause other issues and we do not recommend anyone do this.

[Education]

3 hours ago, Paul said:

That will likely cause other issues and we do not recommend anyone do this.

just sharing it, hope helping the official fix

 

looks like no other problem beside duplicate column name registration_date ?

[Education]

Is there a hot fix yet?

 

Just asking

[Education]

Is there a hot fix yet please?

 

Already more than a month

[Paul]

On 9/14/2024 at 12:07 PM, Education said:

Is there a hot fix yet please?

 

Already more than a month

There is a temporary code fix in the comment on the task https://dev.blesta.com/browse/CORE-5237 An official fix will be in the next release, but if you follow the steps in the comment you can get it working now.