UberCMS Error

Quote:

---

Originally Posted by flx5

Sorry, somehow I've got a "}" too much into the code...
Just corrected it so try again now.

---

Now it says

MYSQL SEEMS OKMYSQL DOES NOT RETURN ANYTHING
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 17 in C:\xampp\htdocs\includes\class.core.php on line 202

That's strange...
What happens when you enter this within PHPMyAdmin:
SELECT maintenance FROM site_config LIMIT 1;

Quote:

---

Originally Posted by flx5

That's strange...
What happens when you enter this within PHPMyAdmin:
SELECT maintenance FROM site_config LIMIT 1;

---

It says in the green box: MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0004 sec )

Execute

Code:

---

"INSERT INTO site_config (maintenance) VALUES (1);

---

and use your original inc.core.php

I had this issue before, I just did this.
and it seemed to fix it.

TRUNCATE TABLE `site_config`

I'm sorry if it doesn't for you.


Kind Regards,
XiFy

Quote:

---

Originally Posted by XiFy

I had this issue before, I just did this.
and it seemed to fix it.

TRUNCATE TABLE `site_config`

I'm sorry if it doesn't for you.


Kind Regards,
XiFy

---

Truncate would empty the table, and as it says it gets a empty result set, exactly that's the problem...

Quote:

---

Originally Posted by flx5

Truncate would empty the table, and as it says it gets a empty result set, exactly that's the problem...

---

Well, I just ran this query and that jump to MySQL error was gone!

Yeah, but" i just ran this query" isn't any explanation and if you know about MySQL then you'd be able to read the error message.
Perhaps you've got a cms that automatically returns 0 when it doesn't receive any data

Quote:

---

Originally Posted by flx5

Yeah, but" i just ran this query" isn't any explanation and if you know about MySQL then you'd be able to read the error message.
Perhaps you've got a cms that automatically returns 0 when it doesn't receive any data

---

I don't really know about MySQL,
All I know is half of C# and PHP i'm learning the rest.

And I use the exact CMS as the OP is using.

Quote:

---

Originally Posted by flx5

Execute

Code:

---

"INSERT INTO site_config (maintenance) VALUES (1);

---

and use your original inc.core.php

---

What do you mean by 'using my original inc.core.php'? How can I use that in SQL?

Sry, I was a bit unprecise...
You should execute the query above with PHPMyAdmin and then replace

PHP Code:

---

public static function GetMaintenanceStatus()
{
   $sql = dbquery("SELECT maintenance FROM site_config LIMIT 1");
   if(!$sql) 
      echo mysql_error();
   else
      echo "MYSQL SEEMS OK";

   if(mysql_num_rows($sql) != 1) 
      echo "MYSQL DOES NOT RETURN ANYTHING";
   else 
      echo "EVERYTHINGS OK";
   
   return mysql_result($sql,0);
} 


---

with

PHP Code:

---

public static function GetMaintenanceStatus()
{
   return mysql_result(dbquery("SELECT maintenance FROM site_config LIMIT 1"),0);
} 


---

Quote:

---

Originally Posted by flx5

Sry, I was a bit unprecise...
You should execute the query above with PHPMyAdmin and then replace

PHP Code:

---

public static function GetMaintenanceStatus()
{
   $sql = dbquery("SELECT maintenance FROM site_config LIMIT 1");
   if(!$sql) 
      echo mysql_error();
   else
      echo "MYSQL SEEMS OK";

   if(mysql_num_rows($sql) != 1) 
      echo "MYSQL DOES NOT RETURN ANYTHING";
   else 
      echo "EVERYTHINGS OK";
   
   return mysql_result($sql,0);
} 


---

with

PHP Code:

---

public static function GetMaintenanceStatus()
{
   return mysql_result(dbquery("SELECT maintenance FROM site_config LIMIT 1"),0);
} 


---

---

Now the website is a Parent Dictionary

what???? Did you delete your index file or what?

Do you test upon localhost or do you have a live site?

Quote:

---

Originally Posted by flx5

what???? Did you delete your index file or what?

Do you test upon localhost or do you have a live site?

---

hold up, i think i accidentally deleted something lmfao.

EDIT

ye i deleted index and stuff, but i put it back and theres no more error. Thanks dude